Transaction management in triggers

Can we give COMMIT or ROLLBACK within a trigger?

Questions by sidd_130

Showing Answers 1 - 5 of 5 Answers

rashmi m

  • Oct 10th, 2012

no triggers cannot use COMMIT and ROLLBACK . And the procedures and functions called by the triggers also cannot use the COMMIT and ROLLBACK.

  Was this answer useful?  Yes


  • Oct 16th, 2012

Although you cant give commit or rollback in trigger directly, still there are ways to give them
You can use the autonomus transactions to do that

  Was this answer useful?  Yes


  • Mar 16th, 2013

Using pragma autonomous_transaction we can use the commit and rollback.

  Was this answer useful?  Yes


  • Feb 17th, 2015

No we cant used it.because it affected on logical processing. It is possible using Pragma

  Was this answer useful?  Yes

Abhijit Musale

  • Feb 19th, 2015

Using PRAGMA AUTONOMOUS_TRANSACTION we can treat the child transaction as a separate transaction, committing which wont affect the parent transaction.

  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