Tags: database, dbms_utility, dbms_utilityformat_error_backtrace, display, format_call_stack, format_error_backtrace, mysql, oracle, package, sql
DBMS_UTILITY.FORMAT_ERROR_BACKTRACE and FORMAT_CALL_STACK
Can someone tell me what's the difference between FORMAT_CALL_STACK and FORMAT_ERROR_BACKTRACE in the DBMS_UTILITY package. Do they display basically the same information as described below ?
Displays a stack of programs and line # that lead to the line the error was raised.
Displays a formatted string showing execution call stack inside PL/SQL application.
I guess the Error back trace only works when there is an error, and call_stack works whether there is error or not.
Can someone verify or shed more light ?
Leave a comment...
- 1 Comments
- I think you've got the basic distinction.
FORMAT_CALL_STACK is what Tom Kyte is using in his who_am_i and who_called_me procedures
FORMAT_ERROR_BACK_TRACE is, as you've surmised, used to figure out the error stack.
Justin#1; Sat, 23 Feb 2008 18:19:00 GMT