Simon Nardin wrote:
Hi!
I'm using perl to access Oracle database. Everything is going well, but
now I have a question about using CursorName. I was searching on the net
for examples without success how to use cursors with "FOR UPDATE" and
"CURRENT OF" construct. Is this possible with Oracle using CursorName?
Maybe do you have an example? Is there an example how to select record
and immediatelly after that updating it?
Just my 2 Cents ...
"FOR UPDATE" and "CURRENT OF" are not SQL but PL/SQL constructs. You can't use them from SQL. You have to write a
package /procedure in order to use them. And as soon as your package, (and sooner if you close your cursor) they (the
cursors) will disapear.
