Sample code below opens a cursor and 'exit when c%notfound;' statement should not trigger 4804 rule violation.
CREATE OR REPLACE procedure TOAD.p_test5 is
cursor c is
select v2 from test2;
ss varchar2(100);
begin
if ss is null then
open c;
loop
fetch c
into ss;
exit when c%notfound;
ss := 'ssd';
end loop;
close c;
end if;
end p_test5;
/
WORKAROUND
None
STATUS
Waiting for fix in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center