Why cant we use commit inside a trigger?

Questions by Nitin kumar

Showing Answers 1 - 3 of 3 Answers


  • Jun 13th, 2013

nO CANNOT Be used

  Was this answer useful?  Yes

prashant mhatre

  • Jun 13th, 2013

can not used ...if we want to use it inside the trigger then use pragma_autonomous.

Varun Tiwari

  • Jul 4th, 2013

Any data transaction control statement can not be used in triggers. As trigger invokes due to any DML event and the transaction may not be successfully commit later and may need to complete rollback.

Pragma_autonomous can be used as an alternate way to commit.

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