Hi,
Can anyone out there explain why I am unable to combine WHERE CURRENT OF and a RETURNING Clause in an UPDATE statement ( in an anonymous PL/SQL Block ). The following is an example of what I am trying to do:
...
...
UPDATE orders
SET order_date = order_date + 7
WHERE CURRENT OF c_ords
RETURNING order_nr INTO v_ord.order_nr ;
...
...
The cursoe c_Ords has been previously declared and the UPDATE statement is embedded in a FOR cursor LOOP.
I get the following error message when trying to compile the code in PL/SQL Developer:
PL/SQL:ORA-00933. SQL command not properly ended.
This isn't a showstopper but nevertheless I'd be very grateful if someone could shed some light on why this is happening. I'm using Oracle 10g,
regards,
Bogman
Can anyone out there explain why I am unable to combine WHERE CURRENT OF and a RETURNING Clause in an UPDATE statement ( in an anonymous PL/SQL Block ). The following is an example of what I am trying to do:
...
...
UPDATE orders
SET order_date = order_date + 7
WHERE CURRENT OF c_ords
RETURNING order_nr INTO v_ord.order_nr ;
...
...
The cursoe c_Ords has been previously declared and the UPDATE statement is embedded in a FOR cursor LOOP.
I get the following error message when trying to compile the code in PL/SQL Developer:
PL/SQL:ORA-00933. SQL command not properly ended.
This isn't a showstopper but nevertheless I'd be very grateful if someone could shed some light on why this is happening. I'm using Oracle 10g,
regards,
Bogman