Toad World® Forums

Code Analysis: Wrong Rule 2603 (Avoid procedure or function calls between a SQL operation and an implicit cursor test)

Since the check is in the next procedure, this should not trigger.

CREATE OR REPLACE PACKAGE BODY test
AS
PROCEDURE test1
AS
BEGIN
INSERT INTO dummy (x) VALUES ( 0 );
call_something();
END test1;

PROCEDURE test2
AS
BEGIN
NULL;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line( SQL%BULK_EXCEPTIONS.COUNT );
END test2;

END test;
/

Hello Peter,

We are going to rewrite this rule (and several others) using a totally different technique. However it may take several months until done. But it’s in the pipeline anyway.

Thanks,
Andre