Return
-
Title
Code Analysis rule 4801 wrongly triggered -
Description
Sample code that triggers rule 4801 violation while it should not since it opens a cursor in IF statement not IF THEN EXIT statement.
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;
/
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.