Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Is there an Event for Capturing Oracle Errors in a Trace File?

Re: Is there an Event for Capturing Oracle Errors in a Trace File?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 17 Sep 2004 09:07:29 +0100
Message-ID: <7765c897040917010713da20e8@mail.gmail.com>


On Thu, 16 Sep 2004 18:51:49 -0700, Andrew V Zitelli <zitelli_at_raytheon.com> wrote:
> Is there an Oracle event that can be set, to capture the details of the
> database session's errors in a trace file ? Use of Oracle event 10046
> provides only a simple indication that an error was raised, but does not
> provide details. For example:

Hi Andrew

I have a small utility on my site that uses a trigger and system events to record arbitrary server errors. You are welcome to have a look and adapt or not as you see fit.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 17 2004 - 03:03:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US