PL/SQL (MOSC)

MOSC Banner

How does cursor treat records processed within the loop - 19C

in PL/SQL (MOSC) 12 commentsAnswered ✓


  • 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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center