Re: multiple trigger for one event

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Fri, 21 Mar 2003 19:33:18 GMT
Message-ID: <3E7B6CCD.1000103@adelphia.net>

Sybrand Bakker wrote:
> On Tue, 18 Mar 2003 09:01:37 +0100, Robert Flügge
> <robert.fluegge_at_bim-consulting.de> wrote:
>
>

>>I have a table with 2 before-insert-triggers.
>>The second one need the result of trigger one.
>>Can I prescribed the order for this triggers ?

>
>
> NO.
> Please refer to your documentation Oracle *doesn't* guarantee the
> order in which triggers are executing.
>
> Hence merge your 2 triggers into one.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Would making the second one an AFTER INERT trigger solve the problem?

  It needs the results of the first trigger anyway.

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost

Received on Fri Mar 21 2003 - 13:33:18 CST