Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA:04092 cannot COMMIT or ROLLBACK in a trigger
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