Re: triggers executing order

Jim Kennedy wrote:
>
> 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
> > >
> > >
> >
> >

just to add, you'll also get a performance benefit. If you compare:

1. trigger with lots of code
2. trigger that calls pkg with lots of code

you'll see that (b) will typically win out

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"