Oracle PL / SQL：如何获取堆栈跟踪，包名和过程名称 [英] Oracle PL/SQL: how to get the stack trace, package name and procedure name

问题描述

有时，异常返回如下：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.

这篇关于Oracle PL / SQL：如何获取堆栈跟踪，包名和过程名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！