SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

regarding FOR UPDATE in cursors

JUPSFeb 1 2009 — edited Feb 2 2009

Hi all!..

i am quite scepticle on FOR UPDATE clause used while declaring Explicit Cursors: Correct me if i am wrong!!

When we declare a cursor with FOR UPDATE.. after opening the cursor the DML exclusive lock is set on all the refered records till the cursor closes thus mainitaining the consistency of data loaded to the context area..

is that the way of it.

regards,
Sreekanth.

This post has been answered by Rob van Wijk on Feb 1 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 2 2009

Added on Feb 1 2009

8 comments

1,351 views