Re: Multiple triggers on one database table

Kevin,

        Triggers are fired in this order:

• before statement-lvl trg
• before row-lvl trg
• the statement-lvl trg
• after-row lvl trg
• after-statement lvl trg

        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