Cancel an Oracle insert statement within trigger

We have a before insert trigger that executes for insertions into TableA... if an error occurs, we need to write a record to TableB and cancel the original insert. From reading the Oracle (8.0.4) documentation, it looks like we can cancel the original insert by using
RAISE_APPLICATION_ERROR. The problem is that this also seems to rollback our insertion into TableB.

Is there a way that we can commit our insert into TableB and cancel the original insert into TableA?

--Mike Ellison
ellison_at_ccmail.nevada.edu

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 28 1999 - 19:56:27 CST