Re: Specifying Trigger Firing Order

Re: Specifying Trigger Firing Order

 

  

It probably does not help you much, but just for the record, it is
possible if you use 11g:

http://www.oracle-base.com/articles/11g/TriggerEnhancements_11gR1.php

Cheers
-- Jan Holst Jensen

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


--
------------------------------------------------------------------------
jan-holst.dk
v/ Jan Holst Jensen
Lindegårdsvej 44, 2. TV Mobil 20 63 40 29
2920 Charlottenlund e-mail [Email address protected]


Oracle LazyDBA home page