CodeXpert is not working as expect when working with PL/SQL conditional compilation.
The following results are expected from a run of Code Xpert:
FUNCTION 3801 Use RETURN as the last statement in a function
NULL 5004 Use of NULL statements.
PARAMETER 5405 Ensure mode of parameter is specified with IN parameter.
PARAMETER 5406 Remove unused parameters of modify code to use the parameter.
... when running on:
CREATE OR REPLACE FUNCTION f (n NUMBER)
RETURN VARCHAR2
IS
BEGIN
$IF $$NOEXECUTE
$THEN
DBMS_OUTPUT.PUT_LINE (NO EXECUTE MODE);
$END
NULL;
END;
... but this does not return any results (select Program Structure for rule set).
But if CodeXpert is run on:
CREATE OR REPLACE FUNCTION f (n NUMBER)
RETURN VARCHAR2
IS
BEGIN
NULL;
END;
... it does return the expected 4 noted results.
WORKAROUND:
none
STATUS:
Waiting for fix in a future version of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy