Re: Specifying Trigger Firing Order

Agree.

We find out it can be a nightmare if you have more then one triggers
and possibly with different owners that should be fired for the same event.

We join all triggers for an table into single one which is defined from
user that own the table.

KAzi

Roger TEDMAN wrote:
> Trigger types fire in a set order but two 'before update' triggers for
example will fire in no set order. If its important, write a procedure
with both sets of code, and call it from a single trigger.
>
>
>
>
>> Message du 04/03/08 22:53
>> De : "Qi Cheng "
>> A : "LazyDBA Discussion"
>> Copie Ã :
>> Objet : Specifying Trigger Firing Order
>>
>> is there any way to specifying Trigger Firing Order?
>>
>>
>>
>> ---------------------------------------------------------------------
>> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>> To post a dba job: http://jobs.lazydba.com
>> To Subscribe : http://www.LazyDBA.com
>> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>>
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>

Oracle LazyDBA home page