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 -> Inserting into an audit table using a PRE-INSERT - Is it possible?

Inserting into an audit table using a PRE-INSERT - Is it possible?

From: James <sqljames_at_aol.com>
Date: Sat, 1 Aug 1998 11:30:05 -1000
Message-ID: <35c4afb9.0@news.hawaii.rr.com>


I wish to write a trigger that will block an insert given certain conditions yet record that bad row to an audit table....how can i do that if i raise a fatal exception which i need to block the insert? If I do that how can the bad row insert into the audit table ever be commited?

thank you in advance, Received on Sat Aug 01 1998 - 16:30:05 CDT

Original text of this message

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