Re: SQL multiples triggers for the same table

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 02 Jul 1999 12:31:20 GMT
Message-ID: <3783b0c2.142488207@newshost.us.oracle.com>

A copy of this was sent to "Erwin jasinski" <hexalog_at_wanadoo.fr> (if that email address didn't require changing) On Fri, 2 Jul 1999 13:36:24 +0200, you wrote:

>Hello !
>Bonjour à tous !
>
>When i use two triggers "before insert" for the same table (only the second
>"for each row"),
>is it possible to indicate the order for the run ?
>

no, the order of the triggers firing is documented to be "not gauranteed". It does appear to fire in a certain order according to the order in which the triggers were created *BUT YOU CANNOT, SHOULD NOT* rely on that as it probably will change from version to version.

Best to put your logic into stored procedures and then create one trigger that calls the procedures in the correct order if order is relevant to you.

>Thank you by advance.
>
>
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jul 02 1999 - 07:31:20 CDT