Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2 b4 update triggers, what is fire sequence?
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