Script: error_stack.sql

    -- -----------------------------------------------------------------------------------
        -- Author       : Pavan Yennampelli
    -- Description  : Displays contents of the error stack.
    -- Call Syntax  : @error_stack
    -- 
    -- -----------------------------------------------------------------------------------
    SET SERVEROUTPUT ON
    DECLARE
      v_stack  VARCHAR2(2000);
    BEGIN
      v_stack := Dbms_Utility.Format_Error_Stack;
      Dbms_Output.Put_Line(v_stack);
    END;
    /