Next: , Previous: , Up: tools   [Contents][Index]


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.