Re: Cancel an Oracle insert statement within trigger

From: <yong321_at_yahoo.com>
Date: Wed, 29 Dec 1999 05:23:41 GMT
Message-ID: <84c5d1$4ko$1@nnrp1.deja.com>

Maybe you can consider the INSTEAD OF trigger. New in Oracle 8.

Yong Huang

In article <84bp79$sdq$1_at_nnrp1.deja.com>, mike_ellison_at_my-deja.com wrote:
> 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.
>

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