Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple event triggers on a table - bug solved?
Hi,
As for me they work in 8.0.3.
SVRMGR> create table test_trg 2> (id integer 3> );
SVRMGR> create or replace trigger test_trg_ins1 2> before insert on test_trg 3> for each row 4> begin 5> :new.id:=:new.id+1; 6> end; 7> /
SVRMGR> create or replace trigger test_trg_ins2 2> before insert on test_trg 3> for each row 4> begin 5> :new.id:=:new.id+1; 6> end; 7> /
SVRMGR> create or replace trigger test_trg_ins3 2> before insert on test_trg 3> for each row 4> begin 5> :new.id:=:new.id+1; 6> end; 7> /
3
1 row selected.
But the order of trigger execution is undefined. Maybe this is your problem?
Andrew Protasov
> Hi,
>
> We use a package that employs multiple insert/update triggers on one
> table. For instance '...trg1..before insert on test' and
> '...trg2..before insert on test'. In earlier versions of the O7 server,
> a bug existed that caused such multiple triggers not to fire at all or
> one would fire, while the other did not etc. I agree that this is not
> particularly neat programming, but we did not program it and have to
> live with it.
>
> Question is: does anyone know whether and in which version of the
> database this bug is solved?
>
> Regards,
> Teus
> _______________________________________
>
>
>
>
Received on Wed Dec 23 1998 - 09:08:40 CST