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;
/
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center