Re: Intermittent ORA-01722 "invalid number"

From: Mladen Gogala <>
Date: Thu, 14 Mar 2013 11:45:25 +0000 (UTC)
Message-ID: <khsd8l$ecd$>

On Wed, 13 Mar 2013 17:25:10 -0700, vsevolod afanassiev wrote:

> We tried to enable event 1722 (alter system set events = '1722 trace
> name errorstack level 3'). I tested it by running SELECT
> TO_NUMBER('123ABC') FROM DUAL; It generated ORA-01722 and trace file was
> produces, it contained SQL statement I was executing in 'name=SELECT..'
> line. However no trace files were generated when this error occurred
> in the application, so there is nothing to send to Oracle to analyze.

The trace wasn't generated because "ALTER SYSTEM" affects only behavior of the newly started processes. Restart the application and the trace will appear.

Received on Thu Mar 14 2013 - 12:45:25 CET

Original text of this message