Next: , Previous: debugger, Up: tools


4.5 PL/SQL Unit Tester

This tool allows you to run procedures, functions, and package members independently. Selecting proper PL/SQL unit will result in anonymous PL/SQL block containing given unit and an environment with setting variables and required outputs with unit results (via DBMS_OUTPUT).

Automatically created code blocks can be modified by user.

What is the Unit Test Script? The anonymous PL/SQL block with the following structure:

     DECLARE
         -- declarations of IN/OUT parameters
         foo number;
         bar varchar2(22);
     BEGIN
         -- definitions of parameters
         foo := 1;
         bar := 2;
         -- calling requested unit
         MYOWN.COOLPACKAGE.FOOBAR(
             foo => foo,
             bar => bar
             );
         -- printing of the results
         sys.dbms_output.put_line('foo: ' || foo);
         sys.dbms_output.put_line('bar: ' || bar);
     END;

It can handle only basic data types currently. No PLSQLdata (record of etc.) supported yet.