COVERAGE pragma marks PL/SQL code which is infeasible to test for coverage. These marks improve coverage metric accuracy.
COVERAGE pragma marks PL/SQL source code to indicate that the code may not be feasibly tested for coverage. The pragma marks a specific code section. Marking infeasible code improves the quality of coverage metrics used to assess how much testing has been achieved.
COVERAGE pragma may appear before any declaration or statement.
COVERAGE pragma argument must have one of these values:
COVERAGE pragma appear with the argument ‘NOT_FEASIBLE’, it marks the entire basic block that includes the beginning of the first declaration or statement that follows the pragma.
COVERAGE pragma with an argument of ’NOT_FEASIBLE_START’ may appear before any declaration or any statement. It must be followed by the
COVERAGE pragma with an argument of ’NOT_FEASIBLE_END’. The second pragma may appear before any declaration or any statement. It must appear in the same PL/SQL block as the first pragma and not in any nested subprogram definition.
An associated pair of
COVERAGE pragmas marks basic blocks infeasible from the beginning of the basic block that includes the beginning of the first statement or declaration that follows the first pragma to the end of the basic block that includes the first statement or declaration that follows the second pragma.
COVERAGE pragma whose range includes the definition or declaration of an inner subprogram does not mark the blocks of that subprogram as infeasible.
Example 14-9 Marking a Single Basic Block as Infeasible to Test for Coverage
This example shows the placement of the pragma
COVERAGE preceding the assignments to z and zl basic blocks. These two basic blocks will be ignored for coverage calculation. The first
COVERAGE pragma (marked 1) marks the first assignment to z infeasible; the second (marked 2) marks the third assignment to z. In each case, the affected basic block runs from the identifier z to the following
IF (x>0) THEN y :=2; ELSE PRAGMA COVERAGE (’NOT_FEASIBLE’); -- 1 z:=3; END IF; IF (y>0) THEN z :=2; ELSE PRAGMA COVERAGE (’NOT_FEASIBLE’); -- 2 z :=3; END IF;
Example 14-10 Marking a Line Range as Infeasible to Test for Coverage
This examples shows marking the entire line range as not feasible. A line range may contain more than one basic block. A line range is marked as not feasible for coverage using a pragma
COVERAGE with a ’NOT_FEASIBLE_START’ argument at the beginning of the range, and a pragma
COVERAGE with a ’NOT_FEASIBLE_END’ at the end of the range. The range paired
COVERAGE pragmas mark all the blocks as infeasible.
PRAGMA COVERAGE (’NOT_FEASIBLE_START’); IF (x>0) THEN y :=2; ELSE z:=3; END IF; IF (y>0) THEN z :=2; ELSE z :=3; END IF; PRAGMA COVERAGE (’NOT_FEASIBLE_END’);
Example 14-11 Marking Entire Units or Individual Subprograms as Infeasible to Test for Coverage
This example shows marking the entire procedure foo as not feasible for coverage. A subprogram is marked as completely infeasible by marking all of its body infeasible.
CREATE PROCEDURE foo IS PRAGMA COVERAGE (’NOT_FEASIBLE_START’); ...... BEGIN .... PRAGMA COVERAGE (’NOT_FEASIBLE_END’); END; /
Example 14-12 Marking Internal Subprogram as Infeasible to Test for Coverage
This example shows that the outer
COVERAGE pragma pair has no effect on coverage inside procedure inner. The
COVERAGE pragma (marked 1) inside the body of inner does mark the second assignment to x as infeasible. Notice that the entire body of procedure outer is marked infeasible even though the pragma with argument ‘NOT_FEASIBLE_END’ is not the last line. The pragma does mark the basic block that includes the statement that follows the pragma and that block does extend to the end of the procedure.
CREATE OR REPLACE PROCEDURE outer IS PRAGMA COVERAGE ('NOT_FEASIBLE_START'); x NUMBER := 7; PROCEDURE inner IS BEGIN IF x < 6 THEN x := 19; ELSE PRAGMA COVERAGE ('NOT_FEASIBLE'); -- 1 x := 203; END IF; END; BEGIN DBMS_OUTPUT.PUT_LINE ('X= '); PRAGMA COVERAGE ('NOT_FEASIBLE_END'); DBMS_OUTPUT.PUT_LINE (x); END; /
In this book:
PL/SQL Units and Compilation Parameters for more information about the PLSQL_OPTIMIZE_LEVEL compilation parameter
In other books:
Oracle Database Development Guide for more information about using PL/SQL basic block coverage to maintain quality
Oracle Database PL/SQL Packages and Types Reference for more information about using the DBMS_PLSQL_CODE_COVERAGE package