Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> AW: Reraising exceptions
<FONT face=Arial color=#0000ff
size=2>Tamas,
<FONT face=Arial color=#0000ff
size=2>
you
could use the "RAISE" statement as last statement in the execption handler
to re-reaise the exception.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>e.g.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>begin
<FONT face=Arial
color=#0000ff size=2>null;
<FONT face=Arial color=#0000ff
size=2>exception
<FONT face=Arial
color=#0000ff size=2>null;
<FONT face=Arial
color=#0000ff size=2>raise
<FONT face=Arial color=#0000ff
size=2>end;
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>regards,
<FONT face=Arial color=#0000ff
size=2>Michael
-----Ursprüngliche
Nachricht-----Von: Szecsy Tamas
[mailto:tszecsy_at_GEOMETRIA.hu]Gesendet am: Mittwoch, 22. August 2001
09:00An: Multiple recipients of list ORACLE-LBetreff:
Reraising exceptions
<FONT face=Arial color=#0000ff
size=2>Hi,
<FONT face=Arial color=#0000ff
size=2>
I am
currently writing some pretty complex triggers. In some cases I would need
catch all exceptions occuring in a procedure call, make some processing (set a
package variable) and then reraise the exception. Can this be
done?
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Every hint will be highly appreciated.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Tamas Szecsy
Received on Wed Aug 22 2001 - 02:17:45 CDT
![]() |
![]() |