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: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 12 Feb 2003 16:40:37 +0800
Message-ID: <3E4A0885.149C@yahoo.com>


Michael wrote:
>
> 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

From what i've seen its based on the object_id, but lets face it, thats a disaster waiting to happen if you rely on that...drop/recreate a trigger and you are toast. If you need order, use one trigger. If you can't change the COTS one, then the other cannot depend on it in any way

hth
connor Received on Wed Feb 12 2003 - 02:40:37 CST

Original text of this message

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