Execute triggers in order wise in PLSQL

[akkumar81]

Hi,

Database: Oracle 10g

Query:

I have a table EMP and i want to execute TRIGGER B, TRIGGER A, TRIGGER C in order wise when i proceed (INSERT values )before insert into EMP tables.

BEFORE INSERT INTO EMP table I WANT TO CALL BELOW TRIGGERS IN ORDER WISE. Is it possible ..?

TRG B;
TRG A;
TRG C;

Thanks,
arun

[Rabbit]

Instead of 3 triggers, make them stored procedures and then use one trigger to call the procedures in the order that you want.

[rski]

From 11g you can set trigger dependencies (with FOLLOW clause). For 10g do what Rabit says ... or combine these three triggers into one if possible.