David,
This comes with the usual caveats (contact oracle support, don't do this
without testing, some fading may occur, objects in the rear view mirror are larger
than they appear)...
On error dumps are pretty straight forward. If you can reproduce the error in
a session, just set it at the session level.
alter session set events '1722 trace name errorstack level 1'
Level 0 - error stack only
Level 1 - 0 + function call stack
Level 2 - 1 + process state
Level 3 - 2 + context (cursor) area
Level 42 - automatically correct error, remove user privileges for running a
bad query, call Domino's and order a large cheese pizza, send the bill to Larry E.
Daniel
"Ehresmann, David" wrote:
>
> List,
>
> I need to trace for a specific Oracle error number, ORA-01722. Any
> suggestions would be appreciated.
>
> thanks,
>
> David Ehresmann
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ehresmann, David
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
