Multiple triggers on a table

Hi All,

I have a clarification on database triggers. I cam to know that from Oracle 7.2 onwards, you can have multiple triggers of the same type on a table. (ie., 2 before insert trigger, 2 after insert trigger ..etc)

Let us say USER1 has a table EMP. He creates a BEFORE INSERT trigger on EMP. USER2 can have BEFORE INSERT trigger on USER1.EMP.

My question is, which trigger will get executed upon INSERTION of a record on USER1.EMP.

To enable multiple triggers on a table, you need to set init.ora parameter COMPATIBLE=7.2 Did any one try this and if so, what is the behavior of the triggers?.

I am not sure what is the underlying principle in implementing this strategy?

Regards

N.Prabhakar Received on Sat Jan 04 1997 - 00:00:00 CST