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!

SELECT FOR UPDATE and SYS_REFCURSOR

513804Aug 7 2006 — edited Aug 7 2006

Hi,

Just experimenting a bit with different cursor declarations and now wondering, why does PL/SQL allow you to open a SELECT FOR UPDATE for a SYS_REFCURSOR (instead of the usual CURSOR), but then complain if you try to update using 'WHERE CURRENT OF'?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 4 2006

Added on Aug 7 2006

4 comments

930 views