15.6.1 Effects of update operations on a retrieval using a cursor
If an update operation is performed during a retrieval using a cursor, the results of the update operation might be applied to the retrieval results, depending on the timing. To prevent the results of update operations from being applied to retrieval results, do the following:
-
Close the cursor before adding or updating rows.
-
Specify data and search conditions in such a manner that the rows to be added or updated are not included in the retrieval results.