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.