This discussion is archived
2 Replies Latest reply: Jan 30, 2013 4:35 AM by yash_08031983 RSS

ERROR IN CURSOR CODE?

yash_08031983 Newbie
Currently Being Moderated
Hello experts,

following cursor code is show invalid rowid error?
  declare
            cursor c2 is
            select deptno,loc from dept where deptno=10 for update of loc;
            begin
            open c2;
            
            update dept set loc='hello' where CURRENT OF c2;
            close c2;
            end;
ORA-01410: invalid ROWID
ORA-06512: at line 7
please help to rectify.

thanks
yash

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points