Transaction management in triggers

Can we give COMMIT or ROLLBACK within a trigger?

Questions by sidd_130

Showing Answers 1 - 15 of 15 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

Arun

  • 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

rocky

  • Mar 16th, 2013
 

Using pragma autonomous_transaction we can use the commit and rollback.

  Was this answer useful?  Yes

Tushar

  • 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