Oracle dbms_utility 几种返回的错误

dbms_utility.format_call_stack

This Function Formats The Current Call Stack. This Can Be Used On Any Stored Procedure Or Trigger To Access The Call Stack. This Can Be Useful For Debugging.

dbms_utility.format_error_stack

This Function Formats The Current Error Stack. This Can Be Used In Exception Handlers To Look At The Full Error Stack.

dbms_utility.format_error_backtrace

This Procedure Displays The Call Stack At The Point Where An Exception Was Raised, Even If The Procedure Is Called From An Exception Handler In An Outer Scope. The Output Is Similar To The Output Of The Sqlerrm Function, But Not Subject To The Same Size Limitation.

Create Or Replace Package pkg_public_back As

  Procedure p_test;

End pkg_public_back;
/

Create Or Replace Package Body pkg_public_back As
  Procedure p_test3 As
    a Number;
  Begin
    a := 0 / 0;
  Exception
    When Others Then
      Raise;
  End p_test3;

  Procedure p_test2 As
  Begin
    p_test3;
  Exception
    When Others Then
      Raise;
  End p_test2;

  Procedure p_test As
  Begin
    p_test2;
  Exception
    When Others Then
      dbms_output.put_line('----format_call_stack----');
      dbms_output.put_line(dbms_utility.format_call_stack);
      dbms_output.put_line('-------------------------');
      dbms_output.put_line('----format_error_stack----');
      dbms_output.put_line(dbms_utility.format_error_stack);
      dbms_output.put_line('-------------------------');
      dbms_output.put_line('----format_error_backtrace----');
      dbms_output.put_line(dbms_utility.format_error_backtrace);
      dbms_output.put_line('-------------------------');
  End p_test;

End pkg_public_back;
/

----format_call_stack----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
32A86CF4        25  package body SCOTT.PKG_PUBLIC_BACK
3297A3D0         2  anonymous block


-------------------------
----format_error_stack----
ORA-01476: 除数为 0


-------------------------
----format_error_backtrace----
ORA-06512: 在 "SCOTT.PKG_PUBLIC_BACK", line 16
ORA-06512: 在 "SCOTT.PKG_PUBLIC_BACK", line 21


-------------------------