Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about triggers
And to add to what Brian posted, you cannot issue an explicit commit or
rollback from within a trigger. The calling program has to issue the
commit or rollback statement. To terminate a transaction from within a
trigger use the procedure raise_application_error.
HTH -- Mark D Powell -- Received on Wed May 24 2006 - 20:13:23 CDT