Re: HELP: Multiple triggers per table?

Peter Beahan wrote:
>
> Hi, please help
>
> I am using Oracle 7.1 and need to be able to create multiple database
> triggers for the same table. We have purchased 2 different software
> packages (for the same database) that use triggers. It appears that we
> have to combine the 2 triggers ourselves to make it work.
>
> Is their anyway of doing this in Oracle 7.1?
> Do later versions of Oracle allow multiple triggers for table and SQL
> statement type (INSERT, UPDATE, DELETE)?
>
> regards Peter

Peter,

You should be able to create multiple triggers, at the same level, in O7.1.x onwards. This, i beleive, was a limitation in O7.0.x. You might need to set the 'compatibile' parameter to 7.1.0 to get this feature working.  

-- 
Cheers

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

Disclaimer : All opinions are truly and just mine.