Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> error during execution of trigger
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
![]() |
![]() |