Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AW: Reraising exceptions

AW: Reraising exceptions

From: <PRIBILLA.Michael_at_EU.DRAGOCO.COM>
Date: Wed, 22 Aug 2001 00:17:45 -0700
Message-ID: <F001.00373700.20010822000540@fatcity.com>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US