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 -> error during execution of trigger

error during execution of trigger

From: Liam Caffrey <caffreylnospam.delete-nospam_at_nortelnetworks.com>
Date: 2000/04/14
Message-ID: <38F7035C.D4B8796E@nortelnetworks.com>#1/1

Would anyone have an idea why this trigger is not working. It compiles OK. Database is 7.3.4
I get the same message in my client application.

Regards

Liam

SQL>
1 CREATE OR REPLACE TRIGGER gqms_distributor_biur_trg 2 BEFORE INSERT OR UPDATE ON distributor 3 FOR EACH ROW
4 declare
5 integrity_error exception;
6 errno integer;
7 errmsg char(200);
8 begin
9 if 1 <> 2 then
10 errno := -20002;
11 errmsg := 'Hello Dolly.';
12 raise integrity_error;
13 end if;
14 exception
15 when integrity_error then
16 raise_application_error(errno, errmsg); 17* end;
18 /

Trigger created.

SQL> update distributor set access_id = 10 where access_id = 11 ; update distributor set access_id = 10 where access_id = 11 *
ERROR at line 1:

ORA-20002: Hello Dolly.
ORA-06512: at "GQMS_DEV.GQMS_DISTRIBUTOR_BIUR_TRG", line 13
ORA-04088: error during execution of trigger
'GQMS_DEV.GQMS_DISTRIBUTOR_BIUR_TRG' Received on Fri Apr 14 2000 - 00:00:00 CDT

Original text of this message

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