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: Insert into a table within a trigger that raises an exception...

Re: Insert into a table within a trigger that raises an exception...

From: Phil Cook <pncook_at_worldnet.att.net>
Date: 1997/12/02
Message-ID: <65vo1f$gt9@bgtnsc03.worldnet.att.net>#1/1

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

Original text of this message

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