Re: Multiple triggers on a table

Prabhakar,

A trigger is always associated to a table not to a user ! The order of execution of these triggers is random. To the best of my knowledge
Oracle does not gaurantee the execution order ( because it is not defined ! )
We use this feature at many places ! It works great ! Infact this feature was available in 7.1x onwards, (though with a bug in 7.1!, got fixed now )

Hope this helps !
Sree Received on Wed Jan 08 1997 - 00:00:00 CST