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?
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