Re: application's raised error going to alert log
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 1 Sep 2010 16:32:25 +0100
Message-ID: <AANLkTikfTSGpAFvJhzdH+A=gF57mZyJPk7eKqO9mQfn7_at_mail.gmail.com>
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.
Date: Wed, 1 Sep 2010 16:32:25 +0100
Message-ID: <AANLkTikfTSGpAFvJhzdH+A=gF57mZyJPk7eKqO9mQfn7_at_mail.gmail.com>
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_at_sanfranmail.com> 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_at_googlemail.com>
To: lyallbarbour_at_sanf...
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_at_sanfranmail.com> wrote:
>
> It's a user defined error num...
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 01 2010 - 10:32:25 CDT