如何在异常处理块中重新引发 pl/sql 异常?

2021-12-24 00:00:00 exception-handling oracle plsql

我有一些应用程序使用以下程序:

I have the following procedure which is used by some applications:

procedure p1
is
begin
  bla bla bla;  
end;

但是没有异常处理块.所以应用程序就是根据这个特性编写的.

But there is no exception handling block. So applications were written according this feature.

现在我需要在 p1 中记录错误.但它不应该影响使用此过程的应用程序.

Now I need to log errors in p1. But it shouldn't affect applications that use this procedure.

像这样:

procedure p1
is
begin
  bla bla bla;

  exception when others then
    log_error(sqlcode, sqlerrm);
    raise_new_exception (sqlcode, sqlerrm);
end;

如果出现 raise_application_error，第一个参数应该在 [-20000, -20999] 范围内.因此，如果引发异常 no_data_found，则不会引发此错误.

In case of raise_application_error first parameter should be in range [-20000, -20999]. So if there raises exception no_data_found, it cannot raise this error.

在exception_init 的情况下，第二个参数不应是可变的.它必须是数字文字.

In case of exception_init, second parameter should not be variable. It must be numeric literal.

PS:作为临时解决方案，我使用立即执行

PS: As temporary solution, I'm using execute immediate

推荐答案

如果你的错误依旧，改成

If your error stays the same, change to 

...
exception when others then
  log_error(sqlcode, sqlerrm);
  raise;
end;
/

这在文档中进行了解释.

相关文章