Loop 2 times on same cursor
827574Nov 4 2011 — edited Nov 4 2011Hi,
If you open a cursor and loop on it, and after the loop is finished, then loop on it again (without closing the cursor in between), will it loop again on the same data as was queried during the opening of the cursor? In other words, will the read-consistency of the active set created when opening the cursor be maintained when looping the second time?
I need to check the data of table A, against table B (= first loop), and then empty table B and fill it with the data from table A (= second loop). But I need to be sure that the data from table A used to compare in the first loop, is exactly the data that is written to table B.
Thanks,
Roel