UTL_CALL_STACK Oracle Database 12C release 1 (12.1)

New package UTL_CALL_STACK is added in Oracle 12C. The package gives more control for format display of call stack, error stack and error backtrace.

CALL STACK – it’s showing call stack from where it was started to where the call stack was examined. In previous release DBMS_UTILITY.FORMAT_CALL_STACK could be used to display it in constant format.

ERROR STACK – it shows full oracle error chain.  In previous release DBMS_UTILITY.FORMAT_ERROR_STACK could be used to display it in constant format.

ERROR BACKTRACE – The backtrace is a trace from where the exception was thrown to where the backtrace was examined. In previous release DBMS_UTILITY.FORMAT_ERROR_BACKTRACE could be used to display it in constant format.

Continue reading