Re: Triggers in specific order

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 20 Jul 1999 22:03:20 +0800
Message-ID: <379481A8.2761@yahoo.com>

Terry Dykstra wrote:
>
> Can you specify in Oracle 8 that similar triggers on a table, e.g. after
> update triggers, fire in a specific sequence? In 7 you cannot as far as I
> know.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.

Nope...They fire in object_id order, that is, in the order that they were created...(but I wouldn't rely on that as an ordering mechanism)...

Why not coalesce the logic of the two triggers into one...?

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Jul 20 1999 - 09:03:20 CDT