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

Home -> Community -> Usenet -> c.d.o.server -> Reraising exceptions

Reraising exceptions

From: Charles R. Conti <crconti_at_ix.netcom.com>
Date: Fri, 02 Apr 1999 07:38:37 -0800
Message-ID: <3704E47D.FA2F520E@ix.netcom.com>


Will the insert take place in this piece of code

DECLARE
   err_num NUMBER;
   err_msg VARCHAR2(100);
BEGIN
...

EXCEPTION
...

   WHEN OTHERS THEN

      err_num := SQLCODE;
      err_msg := SUBSTR(SQLERRM, 1, 100);
      INSERT INTO errors VALUES (err_num, err_msg);

     RAISE;   /* or RAISE_APPLICATION_ERROR */
END; Received on Fri Apr 02 1999 - 09:38:37 CST

Original text of this message

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