pl/sql cursor fetch new rows entered

[oerrora]

hi!
I have small issue which I can only test when it goes to production. Before that I have design code and release it. I have pl/sql anonymous block in which I open a cursor to update set of rows. This table gets rows inserted round the clock. While updating these rows, there is possibility of new rows getting into table which satisfy my opened cursor condition.

My question is, can those new records also be fetched in the cursor or not? My requirement is they should not be fetched. The volume of records getting updated may be in thousands.

I would appreciate your help.

Thanks in Advance.

 

[rcurva]

You don't have to worry, once the cursor is open, no new records can be added in it
. Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War