Re: DB Trigger (Feature???)

Jim Smith wrote:
>
> In article <19961112022100.VAA14381_at_ladder01.news.aol.com>,
> alexjent_at_aol.com writes
> >It is my understanding from Oracle manuals etc. that one and only one
> >db tigger(of the same type) can be created for the same table(same
> >instance etc.).
> >
> >In other words, if I create a trigger script (IE: Before Insert on table
> >X) and run it
> >once, the trigger is created. If I rename the trigger but leave the
> >script intact and
> >run it....it should produce an error(or so sez Oracle). We are running
> >Version 7.1.X.X.X.
> >
> >It this an undocumented feature? A documented feature? A mirage?
>
> If it says it in the manuals (see your first paragraph) it must be a
> documented feature.
> >
> It is a documented feature in versions prior to 7.2 or perhaps 7.3. Try
> looking up triggers in the manual.
>
> The situatin used to be that you could have 12 triggers per table, the
> product of update,insert,delete, pre and post, and statement or row.
> --
> Jim Smith

The limitation of 12 triggers per table has been lifted from O7.1.x version. So if you are running a version > 7.1.x, you should be able to create multiple triggers of the same type on the same table. Oracle, however, does not guarantee the firing order - which i thought would 've been very handy.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.