PL/SQL Library Test Script

Paste this code into a .sql script and run it in SQL*PLUS by the owner of the target schema.

SET SERVEROUTPUT ON SIZE 1000000; -- Test p_script_lib: DECLARE l_... l_passed BOOLEAN := TRUE; BEGIN dbms_output.put_line('-'); dbms_output.put_line('FUNCTION function test start:'); dbms_output.put_line('-'); dbms_output.put_line ('Test 1: Pass ...: Description.'); dbms_output.put_line ('Expected result: ...'); l_... := p_..._lib....(...); dbms_output.put_line('Result = ' || l_...); IF l_string = ... THEN dbms_output.put_line('---PASSED---'); ELSE dbms_output.put_line('---FAILED---'); l_passed := FALSE; END IF; dbms_output.put_line('-'); dbms_output.put_line('FUNCTION function test end:'); IF l_passed =TRUE THEN dbms_output.put_line('---PASSED---'); ELSE dbms_output.put_line('---FAILED---'); END IF; dbms_output.put_line('-'); END; /