Oracle Error Stack Viewer
This script displays the current PL/SQL error stack. It uses the DBMS_UTILITY.FORMAT_ERROR_STACK function to retrieve and print detailed error information, which helps developers diagnose and debug PL/SQL exceptions.
oraclepl-sqlmonitoring-alertsv1.0.0
0 stars0 downloads13 views0 comments
By OracleDba • Created
Code
(15 lines)123456789101112131415
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/error_stack.sql
-- Author : Tim Hall
-- Description : Displays contents of the error stack.
-- Call Syntax : @error_stack
-- Last Modified: 15/07/2000
-- -----------------------------------------------------------------------------------
SET SERVEROUTPUT ON
DECLARE
v_stack VARCHAR2(2000);
BEGIN
v_stack := Dbms_Utility.Format_Error_Stack;
Dbms_Output.Put_Line(v_stack);
END;
/