Why cant we use commit inside a trigger?

Questions by Nitin kumar

Showing Answers 1 - 9 of 9 Answers

ABHAY

  • 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