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