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

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 12 Feb 2003 06:17:22 +0100
Message-ID: <v5mj4v4ch8uvsp98dg2frm0qk3785f3r6d@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:17:22 CST