-224 THE RESULT TABLE DOES NOT AGREE WITH THE BASE TABLE USING cursor-name
Explanation
A positioned UPDATE or DELETE was attempted on a row that no longer matches its previous condition. The column values in the result table row no longer match the current values in the base table row. The row was updated after it was inserted into the result table but before the positioned update or delete was completed.
- cursor-name
- The name of the cursor that was used for the positioned update or delete.
System action
The statement cannot be processed. The cursor is positioned on the same row.
Programmer response
Correct the application program to handle this error condition, or change the isolation levels so that the base row cannot be updated during the cursor operation.
SQLSTATE
24512
