Debugging Code

To debug a code there are advanced techniques but in basic cases dbms_output package can easily be used; it provides procedures to enable buffering, to create output and to retrieve the output; enable, put_line, get_line.

BEGIN
dbms_output.put_line('Debug test');
END;
/

This output is created in buffer though if wanted output can be written to a table.