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

From: Doug Swanson <dswanson_at_hms.harvard.edu>
Date: 1997/12/02
Message-ID: <3484156C.F06C42E1@hms.harvard.edu>#1/1

Phil-

Sorry for not being more specific...

By 3rd party app, I meant and application out of my control (i.e. one that I cannot alter). It sounds like you're describing the situation where I can decide if the app writes to the database or not.

Thanks for the effort anyway.
-Doug

Phil Cook wrote:

> 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