Hi, we're working on MSSQL Server 2019.
we're trying to update a Table in SQL Server with data received over linked server from oracle.
we get error:
OLE DB provider "OraOLEDB.Oracle" for linked server "mp_abo_db" returned message "ROW-00014: Cannot update row as the data in the database has changed".
Msg 7343, Level 16, State 4, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "mp_abo_db" could not UPDATE table "[OraOLEDB.Oracle]".
when we restrict the query to 99 rows the update is working.
and the update is working also on SQL Server 2012.
can anyone help me to investigate this issue ?
thanks & regards
Chris