Regarding Ref Cursor
HI,I am having a doubt in this point of view
A Ref Cursor is not Updatable. The Result set represented by ref cursor is read-only. you cannot update the data base using ref cursor
But i had observed that in both cases i am able to update the data base using these examples
using static cursor
declare
A Ref Cursor is not Updatable. The Result set represented by ref cursor is read-only. you cannot update the data base using ref cursor
But i had observed that in both cases i am able to update the data base using these examples
using static cursor
cursor c is select * from emp;
v_all c%rowtype;
begin
open c;
loop
exit when c%notfound;
fetch c into v_all;
update drk_emp set ename=v_all.ename||'Test' where empno=v_all.empno;
end loop;
close c;
end;
0