How does cursor treat records processed within the loop - 19C
- I have a cursor that opens say ten records based on the condition that those are unprocessed. Say Process_flag ='U'.
- I open the cursor and start processing the first record, and in the process, need to update process_flag of one or more records in the pipeline and to be processed next that are opened by the same cursor.
Question : Once a record is updated , will the cursor still continue to treat the next record's process_flag ='U' that was originally the case when cursor was opened? Or, since the process_flag got updated just now, it will omit that record, though originally was part of the opened records?