wtPLSQL Project

wtPLSQL is a white-box testing framework for Oracle database objects.

Website Home Page

Best Practices

Place the “WTPLSQL_RUN” procedure at the end of the package body. This allows the procedure call any procedure/function in the package.

Place the ”–% WTPLSQL SET DBOUT” annotation next to the WTPLSQL_RUN procedure definition in the package body.


Separate “setup” and “teardown” steps into their own Test Cases.**

Use words consistently in Test Case names.

Include tests for boundary conditions

Create test procedures for each procedure/function in a DBOUT PACKAGE BODY.

Use conditional compilation select directive “WTPLSQL_ENABLE” in the Oracle database initialization parameter “PLSQL_CCFLAGS” to enable and disable embedded test code in all PACKAGE BODYs.

Use consistent begin and end test code markers for embedded tests. These examples will setup conditional compiling and annotate lines of code to be excluded from code coverage calculations.

$IF $$WTPLSQL_ENABLE  -------%WTPLSQL_begin_ignore_lines%-------
$END  ----------------%WTPLSQL_end_ignore_lines%----------------

Keep embedded test code indented between the test code markers

Add WTPLSQL markers every 10 lines or less in an embedded procedure. This helps identify a long embedded test procedure while scrolling through source code. When in doubt, add more of these.

   --------------------------------------  WTPLSQL Testing --

Check and/or set NLS settings before testing. Many data types are implicitly converted to VARCHAR2 before comparison. The “wtplsql” package includes functions to check and set NLS settings. Note: Modifying these settings always includes a COMMIT.

Website Home Page