Suppose I have 2 triggers on table T, tr1- a before insert trigger & tr2- a before update trigger.tr1 has update (T) statement inside body of tr1andtr2 has insert (T) statement inside body of tr2Now, I'm tring to insert a row into T.What will hppn??

Bavani

• Oct 13th, 2006

 

You will get a mutating table error.

because you cannot do any DML statements inside the trigger which is used by the same table you are updating or inserting.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 5th, 2006

 

1.   This process is called creating recursive trigger which causing the table in mutating stage.

2. you cannot do two DML statements in one statement.

trupti

• Feb 13th, 2007

 

Hi, you can use pragma autonomous_transaction for mutating trigger ie after declare, the first statement is pragma autonomous_transaction.
try it,
it really works!!

gkbiswal

 Profile Answers by gkbiswal 

• Oct 21st, 2007

 

It(autonomous transaction) will work but it'll not satisfy your business requirement. Mutating error is not actually an error but Oracle has provided this feauture to do away with any side effects due to the bad application design. Therefore mutaing rror means, sometning is wrong with the application design.