Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

DBMS_UTILITY FORMAT_CALL_STACK and DBMS_UTILITY FORMAT_ERROR_STACK

SQL> SQL> CREATE OR REPLACE PROCEDURE error_test1 AS   2  BEGIN   3     RAISE VALUE_ERROR;   4  END error_test1;   5  / Procedure created. SQL> CREATE OR REPLACE PROCEDURE error_test2 AS   2  BEGIN   3     error_test1;   4  EXCEPTION   5     WHEN OTHERS THEN   6        DBMS_OUTPUT.PUT_LINE(DBMS_UTILITY.FORMAT_CALL_STACK);   7        DBMS_OUTPUT.PUT_LINE(DBMS_UTILITY.FORMAT_ERROR_STACK);   8  END error_test2;   9  / Procedure created. SQL>