ORA-01722: invalid number, problem with alter session set NLS_NUMERIC

Home -> Community -> Usenet -> c.d.o.server -> ORA-01722: invalid number, problem with alter session set NLS_NUMERIC_CHARACTERS

From: Stein Andersen <stein.andersen_at_no.ibm.com>
Date: Mon, 7 Jan 2002 12:05:04 +0100
Message-ID: <a1bvcq$fak$1@news.btv.ibm.com>

Hi
I dont understand whats happing with NLS_NUMERIC_CHARACTERS (NT).

Inserting NUMBER-value in a VARCHAR2-field in a table (legacy system) using ODBC (and
Microsoft ODBC Driver for Oracle) and SQL*Net, value are processed by a trigger, and copied
to a NUMBER-field in another table. The legacy system are always deliviring the number in
american numeric format, are therefore immediatly after starting the legacy application using:

"ALTER SESSION SET NLS_NUMERIC_CHARACTERS='.,'" It seems that NLS_NUMERIC_CHARACTERS somethimes are reset to the default configuration
(usually NLS_NUMERIC_CHARACTERS=',.') after som time, the legacy application
will then fail.

Has anybody experienced this kind of reset, and what may be the reason
(Oracle 8.x) ??

How may I automaticly detect if an change in NLS_NUMERIC_CHARACTERS has occured.

Thanks
Stein Received on Mon Jan 07 2002 - 05:05:04 CST