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>