Hi Bill,
The FOR UPDATE clause syntax allows for the possibility of column-level locking, but
Oracle only implements row-level
locking. So the OF column_name phrase is just ignored.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original
Bill,
The name of the column(s) specified is only there to specify which table(s)
rows to lock. The SQL manual says it better (and more concisely) than I can:
SQL Manual snippet
OF Locks the select rows only for a particular table in a join. The columns
in the OF clause only specify which
Hi Bill,
I didn't really do much checking, but my guess is that
the 'WHERE CURRENT OF' works here because you're
selecting * in the cursor.
If you, for instance, select columna_a as supposed to
*
then you will most likely get the error.
My guess is that this is just how ORACLE locks the
set