In Oracle 10g, the PLSQL_LINE predefined inquiry directive is a PLS_INTEGER literal value indicating the line number reference to $$PLSQL_LINE in the current program unit. In other words, $$PLSQL_LINE is the number of the line where $$PLSQL_LINE appears in your PL/SQL code.

Another useful predefined inquiry directive is PLSQL_UNIT which is a VARCHAR2 literal value indicating […]

There are two built-in Oracle PL/SQL functions that return the error message associated with the error code of the most recently raised exception in your PL/SQL block. The first function is SQLERRM. The second is the less known function DBMS_UTILITY.FORMAT_ERROR_STACK.

Which one to use? To answer this question, let us first review the details of each […]

To eliminate errors in your Oracle PL/SQL programs, it is very important to find the line number on which the error had occurred. The question is how to find that line number.

Before Oracle Database 10g Release 1, the only way to know the line number is to let the exception go unhandled in your PL/SQL […]