Nipun Tomar
Can we use commit in trigger?
By Nipun Tomar in Databases & DBA on Dec 17 2013
  • Keerthi Venkatesan
    Apr, 2016 20

    no.

    • 0
  • Kml Surani
    May, 2015 13

    No

    • 0
  • Munesh Sharma
    Apr, 2014 13

    yes

    • 0
  • Narendra Kumar
    Apr, 2014 2

    Yes ,You can Commit inside the trigger.But for this you have to make this trigger transaction to be a Independent transaction from its parent transaction, You can do this by using Pragma. Pragma AUTONOMOUS_TRANSACTION allow you to build the Independent(child) Transaction,started by another. Should be declare in DECLARE section of any subprogram.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS