How to re-raise pl/sql exception in exception handling block?

Question

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.

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

Something like this:

procedure p1
is
begin
  bla bla bla;

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

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.

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

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

Solution

If your error stays the same, change to

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

This is explained in the documentation.

Comments

[ceving]

@AlexPoole Link dead.

[Alex Poole]

@ceving - thanks, I've put the current live link into the answer instead to it's easier to update in future.

[loshad vtapkah]

Current link

[McK]

@AlexPoole Link dead again. loshad vtapkah's link works currently.

[Alex Poole]

@McK - thanks; updated to current 11gR2 version which is what it used to point to (rather than the 9i one loshad linked to).

[Nick]

Bad thing about raise is that it removes the error backtrace :(