Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Multiple triggers on one database table

Re: Multiple triggers on one database table

From: Thumper <tdrudy_at_ix.netcom.com>
Date: Tue, 14 Jul 1998 20:37:44 -0700
Message-ID: <35AC2408.8AF@ix.netcom.com>


Kevin,

        Triggers are fired in this order:

        Order of creation has nothing to do with the order in which triggers are fired.

        Hope this helps.

                        Tom

Kevin K. Alexander wrote:
>
> I am attempting to use multiple triggers on a database table. We have done
> testing which proves it works and the triggers are fired. The issue we
> cannot definitively nail down is the order in which the triggers will be
> fired. It appeared from our testing, that the triggers were fired in the
> order we created them. Can anyone enlighten me on the official stance
> taken by Oracle (version 7.x...) with regard to this issue?
> Thanks
> Kevin
> kev_at_cyberramp.net
Received on Tue Jul 14 1998 - 22:37:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US