Oracle PL/SQL:如何获取堆栈跟踪、包名称和过程名称
有时异常返回类似:ORA-06502:PL/SQL:数字或值错误:字符串缓冲区太小".
Sometimes the exception returns something like: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small".
它不是那么易读，因为它既不报告表、列和它试图写入的值.
It's not so readable since it doesn't report neither the table, the column and the value it tried to write.
在异常发生或被捕获时获取当前过程名称会很有用.
it would be useful to get the current procedure name at the moment the Exception happened or is catched.
我如何获得它?
推荐答案
您可能想要 DBMS_UTILITY.FORMAT_ERROR_BACKTRACE 函数
You probably want DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function
SQL> ed
Wrote file afiedt.buf
1 create or replace procedure p1
2 is
3 begin
4 raise_application_error( -20001, 'Error 1', true );
5* end;
SQL> /
Procedure created.
SQL> create or replace procedure p2
2 as
3 begin
4 null;
5 p1;
6 end;
7 /
Procedure created.
SQL> begin
2 p2;
3 exception
4 when others then
5 dbms_output.put_line( dbms_utility.format_error_backtrace );
6 end;
7 /
ORA-06512: at "SCOTT.P1", line 4
ORA-06512: at "SCOTT.P2", line 5
ORA-06512: at
line 2
PL/SQL procedure successfully completed.
相关文章