The purpose of this article is to cover techniques that are useful in debugging PL/SQL code, especially if you don’t have access to a debugger such as the one that comes packaged with SQL Developer (this has been the case for me a few times).

This article will cover the following topics:

• Using DBMS_DBMS_OUTPUT + PUT_LINE.
• Using SELECT FROM DUAL.
• Using raise_application_error + SQLCODE + SQLERRM.
• Using the EXEC command.