Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to use combination of WHERE CURRENT OF and RETURNING

Status
Not open for further replies.
bogman

bogman

Instructor
Jan 15, 2002
13
0
0
GB
Hi there,

I have recently noticed that I am unable to combine the 'WHERE CURRENT OF ' and 'RETURNING .. INTO .. ' clauses in the same UPDATE statement ( when processing cursor rows in a PL/SQL block). It's not a big problem but I can't think of a logical reason why this is not allowed. A sample update and the error message are displayed below where c_emp is the name of a previously declared CURSOR:

UPDATE employee
SET salary = r_emps.salary
WHERE CURRENT OF c_emp
RETURNING salary INTO r_emps.salary;

RETURNING salary INTO r_emps.salary;
*
ERROR at line 37:
ORA-06550: line 37, column 6:
PL/SQL: ORA-00933: SQL command not properly ended

Can anyone out there enlighten me?
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
176
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
1K
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
116
Livia8
Livia8
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
151
SkipVought
S
Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
326
carp
carp

Part and Inventory Search

Sponsor

Back
Top