2 Replies Latest reply: Jan 30, 2013 6:35 AM by yash_08031983 RSS

    ERROR IN CURSOR CODE?

    yash_08031983
      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