Raise Application Error

From: Reid Lai <reidlai_at_hk.super.net>
Date: 1995/06/30
Message-ID: <3t8use$pv2_at_tst.hk.super.net>#1/1

Hi world,

Recently I have written a stored procedure with OTHER exception for insertint a row into a given table. This table have a trigger which will be performed after insertion. If the row is invalid, the trigger will raise application error -20000. Once this application error occurs, the OTHER exception cannot trap this error. The following is a part of my script:

CREATE OR REPLACE PROCEDURE procA IS
BEGIN
.
.

  (Some assignment statements)
.
.
.

  INSERT INTO tableA VALUES(...) ;
  COMMIT ;
EXCEPTION
  WHEN OTHERS THEN

     ROLLBACK ;
     INSERT INTO tableErrorTable VALUES(...) ;
     COMMIT ;

END; The trigger did use RAISE_APPLICATION_ERROR(-20000,error_message).

If any one can help me to solve my problem or want more about the situation. Please send me e-mail at reidlai_at_is1.hk.super.net.

Thanks

---

Reid Lai
reidlai_at_hk.super.net Received on Fri Jun 30 1995 - 00:00:00 CEST