Anurag is correct. Do not rely on the order that the triggers were created
for evaluation order. Instead have 1 trigger and call pl/sql packages.
Then you can control the order, and have code that is more efficient.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Anurag Varma" <avdbi_at_hotmail.com> wrote in message
news:k1UDa.159$IT4.97_at_news02.roc.ny.frontiernet.net...
> You can't influence the executing order of similar type triggers(like
before row trigger).
> Read the docs ... its stated in there.
> .. and no .. I don't think its mentioned anywhere that the executing
order depends on creation order.
>
> This sparks a question? Why would you want an order?
>
>
> Anurag
>
>
>
> "Gabor Konrad" <gkonrad_at_freemail.hu> wrote in message
news:bbom29$bvj6a$1_at_ID-180124.news.dfncis.de...
> > Hi!
> >
> > Can I influence my triggers executing order?
> > (So far I believe the executing order depends on the trigger creation
order.
> > It is not true)
> >
> > GK
> >
> >
>
>
Received on Thu Jun 05 2003 - 22:48:39 CDT
