delete a row in pl/sql

[mokesql]

hi guys!
i wanna delete a row from a table with pl/sql, but it`s not possible with the where current of curser funktion. where could be the error. it returns me the message that the curser must be declared with FOR UPDATE to use with CURRENT OF. plese help me ansd say what i should declare as for update. thx

kemo

 

[rcurva]

For your cursor:

cursor my_curr is
Select col1, ...
from table1
where ...
for update of columns_2b_updated nowait;


For your update:

update table1
set columns_2b_updated = ...
where current of my_curr;