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 -> Re: Multiple event triggers on a table - bug solved?

Re: Multiple event triggers on a table - bug solved?

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Wed, 23 Dec 98 17:08:40 +0200
Message-ID: <AEuTGWsK42@protasov.kiev.ua>

Hi,

As for me they work in 8.0.3.

SVRMGR> create table test_trg
     2> (id integer
     3> );

Statement processed.
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> /

Statement processed.
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> /

Statement processed.
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> /

Statement processed.
SVRMGR> insert into test_trg(id) values(0); 1 row processed.
SVRMGR> select * from test_trg;
ID

         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

Original text of this message

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