Re: multiple trigger for one event

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Sun, 23 Mar 2003 13:03:49 GMT
Message-ID: <3E7DB48C.6000100@adelphia.net>

DA Morgan wrote:

> Ed Prochak wrote:
> 
> 

>>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

[]

> 
> Why are you fighting putting the code into a single trigger? Is there
> some point in this that I am missing?
> 
> Daniel Morgan
> 

I agree that the best solution is one trigger.

Using the AFTER trigger would just be a work around. (Maybe he can't access the code of the first trigger for some bizarre reason.) Just looking at alternatives.

-- 
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 Sun Mar 23 2003 - 07:03:49 CST