Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert into a table within a trigger that raises an exception...
Doug,
Why don't you test the record, if good insert, otherwise, log the bad
records to a table
instead of raising an exception, and just send a message to the user. You
cannot
commit inside a trigger so the trigger either fails or succeeds in it's
entirety.
Phil Cook
Certified Oracle DBA
Received on Tue Dec 02 1997 - 00:00:00 CST