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: 2 b4 update triggers, what is fire sequence?

Re: 2 b4 update triggers, what is fire sequence?

From: Michael <missed-spam_at_worldnet.att.net>
Date: Tue, 11 Feb 2003 23:50:10 -0600
Message-ID: <Q7l2a.16669$AR5.7875@fe02.atl2.webusenet.com>


Right, it's not guaranteed. Anyway, I doubt they intentionally stick a randomizing element in the process.

How is firing sequence determined?

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:v5mj4v4ch8uvsp98dg2frm0qk3785f3r6d_at_4ax.com...
> On Tue, 11 Feb 2003 21:31:24 -0600, "Michael"
> <missed-spam_at_worldnet.att.net> wrote:
>
> >I have two before update row level triggers on a table.
> >Trigger A I can do anything I want to
> >Trigger B came with a COTS package and I can't modify it.
> >
> >How can I make Trigger A always fire first? What determines the firing
> >sequence? Is it something like compilation time?
> >
> >
> The firing sequence is random and NOT guaranteed, as documented.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Feb 11 2003 - 23:50:10 CST

Original text of this message

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