FORMAT_ERROR_BACKTRACE in the DBMS_UTILITY package has been introduced in the Oracle version 10g. Format error backtrace is use to find the exact position where the exception has occurred.
When an exception is raised, one of the most important piece of information that a developer would like to know is the line of code that raised that exception for that we are using Format Error Backtrace.
Other then FORMAT_ERROR_BACKTRACE we use FORMAT_ERROR_STACK and FORMAT_CALL_STACK Functions.
To find the error we are using below functions
When an exception is raised, one of the most important piece of information that a developer would like to know is the line of code that raised that exception for that we are using Format Error Backtrace.
Other then FORMAT_ERROR_BACKTRACE we use FORMAT_ERROR_STACK and FORMAT_CALL_STACK Functions.
To find the error we are using below functions
- FORMAT_ERROR_BACKTRACE
- FORMAT_ERROR_STACK
- FORMAT_CALL_STACK.
Example: