4
Reply

Can we use commit in trigger?

Nipun Tomar

Nipun Tomar
11y
3.2k
0
Reply
    Keerthi Venkatesan
    no.
    Keerthi Venkatesan
    9y
    0
    Kml Surani
    No
    Kml Surani
    10y
    0
    Munesh Sharma
    yes
    Munesh Sharma
    11y
    0
    Narendra Kumar
    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.
    Narendra Kumar
    11y
    0
Message