Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA:04092 cannot COMMIT or ROLLBACK in a trigger

Re: ORA:04092 cannot COMMIT or ROLLBACK in a trigger

From: Phil Cook <pcook_at_iamerica.net>
Date: 1997/07/06
Message-ID: <01bc8a2d$708ecf20$7ef9adcd@phil-cook-laptp>#1/1

Some of our vendor-supplied code will perform an after statement trigger that will cleanup any partial transactions using values stored in a pl/sql table which were placed by the initial row trigger(s). It's messy but gets around the limitation of no rollbacks or commits inside a trigger.

        Phil Cook Received on Sun Jul 06 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US