Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Inserting into an audit table using a PRE-INSERT - Is it possible?
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