Re: Catching errors on inserts

It is in the session trace file not the alert log file.

Anjo.

On Wednesday 21 August 2002 16:38, you wrote:
> Gogala
>
> Thanks for the tip this seems like just what I'm looking for,
> however I must be doing something wrong as no errors are getting written
> to my <SID>alrt.log
>
> Im running oracle 8.16 server on win2kpro (this is a development
> database)
>
> I just got around to running/testing this from my post last week
>
> I do
> SQL> alter session set events='0001 trace name errorstack forever,
> level 10';
>
> Session altered.
>
> Then I run the offending insert script which show errors being thrown
>
> I check the <SID>alrt.log in BDUMP dir and all it show are my regular
> .ORA logs being written
> EG
> Wed Aug 21 09:19:07 2002
> Thread 1 advanced to log sequence 3240
> Current log# 4 seq# 3240 mem# 0:
> D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG4LTRACK2.ORA
> Thread 1 advanced to log sequence 3241
> Current log# 1 seq# 3241 mem# 0:
> D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG1LTRACK2.ORA
> Thread 1 advanced to log sequence 3242
> Current log# 2 seq# 3242 mem# 0:
> D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG2LTRACK2.ORA
> Thread 1 advanced to log sequence 3243
>
> Also checked the <SID>alrt.log in Oracle\home\database
> Nothing written there
>
> What am I missing?
>
> > alter session set events='0001 trace name errorstack
> > forever, level 10'; All "duplicate value" errors will then be
> > trapped in the alert.log file. You can always substitute your
> > own favorite error in place of 0001.
>
> Also If you have a extra min how can I substitute the error message?
>
> Thanks for your help
>
> Bob

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).