What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

 Mutation of table occurs.
  • Interview Candidate
  • 4
  • 4328

Showing Answers 1 - 4 of 4 Answers

Sunil Yadav

  • Oct 26th, 2005
 

To avoid the mutation table error ,the procedure should be declared as an AUTONOMOUS TRANSACTION.

By this the procedure will be treated as an separate identity.

rudra pratap

  • Jul 5th, 2007
 

In order to avoid mutation table error we need to have a row level as well as a statment level trigger.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions