What is the issue here? That sounds like relatively sensible error handling - log the error to a table and the alert log so that monitors pick it up and diagnosis can happen at a suitable point and then raise an exception for the end user. On 1 Sep 2010 15:58, <lyallbarbour@xxxxxxxxxxxxxxx> wrote: Oh, nope. no traces. The company who made the app is also inserting a record into an error log table. Maybe i should just ask them to do that and cut out the RAISE_APPLICATION_ERROR statement in the TRIGGER. -----Original Message----- From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx> To: lyallbarbour@xxxxxxx Sent: Wed, Sep 1, 2010 10:48 am Subject: Re: application's raised error going to alert log No, I meant has someone already set a trace for it (perhaps in init.ora, or a login trigger)? On 1 September 2010 15:27, <lyallbarbour@xxxxxxxxxxxxxxx> wrote: > > It's a user defined error num...