Re: ORA-01722

[Sean Molloy <seanm@bwc.org>]

   Thank you very much, this was the source of the problem.

   Oracle Financials says to set NLS_NUMERIC_CHARACTER to ".,"

   Unfortunately one of our DBA's set it to '.,'

   We have set it to its correct value and this fixes the problem. We 
also had a report of starnge behavior by oracle in formatting numeric 
output on this instance. This problem was again caused by the incorrect 
setting of NLS_NUMERIC_CHARACTER.

   Thank you for your prompt help.

Sean

On Tue, 10 Oct 1995, Oracle 7 wrote:

> Date: Tue, 10 Oct 1995 18:15:05 -0600
> From: Oracle 7 <oracle7@miti.com>
> To: seanm@bwc.org
> Subject: ORA-01722
> 
> I looked again for cases in our HelpDesk that involved ORA-01722. I found a
> similar case to yours. They upgraded from 7.1.3.0.0 to 7.1.3.2.1 and starting
> getting the ORA-01722 error. We found that the NLS_NUMERIC_CHARACTER entry
> in their init.ora file was incorrect. It was "'.,'" and should have been
> ".," . This is something that may be worth checking.
> 
> John L. Kellogg
> MITI Technical Support Manager
>