| Updating Ref Cursor [message #22574] |
Thu, 17 October 2002 11:27  |
Rishabh
Messages: 6
Registered: July 2002
|
Junior Member |
|
|
I am trying to update the current row of a cursor(of type ref cursor) and it is giving me the following error
(1):PLS-00413: identifier in CURRENT OF clause is not a cursor name
(2):PL/SQL: SQL Statement ignored
Here is the code :
***************************
Procedure TEST is
type cur is ref cursor ;
my_cursor cur ;
begin
open my_cursor for
select * from my_table where
my_id = 100 for update ;
update my_table set my_name = 'TEST' where
current of my_cursor ;
END ;
Please suggest.
RJ
|
|
|
|
| Re: Updating Ref Cursor [message #22577 is a reply to message #22574] |
Thu, 17 October 2002 11:34  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
I think "where current of" really uses ROWID as the underlying mechanism to specify which row to update, so I'd simply add rowid to your cursor and then use that rowid in a seperate update statement.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
