NLS_NUMERIC_CHARACTERS

[Pletinckx]

Hi,
I transfer datas from a txt file to my database oracle 8. From my portable
PC, everithing is correct. From any other PC, I get an error message :
invalid number.
My number format is point for decimals ans space for thousand separator. I
tried to change my registry with the key : NLS_NUMERIC_CHARACTERS . ( point
space ) but the system keeps point comma.
When I look for the parameters of my DB, I get :

SQL> select * from NLS_DATABASE_PARAMETERS ;
PARAMETER VALUE
------------------------------ ----------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MM-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8ISO8859P1
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
NLS_RDBMS_VERSION 8.0.5.0.0

Can I put a line of code in my program to modify this ? If yes, wich code?

Can you help me?

Cheers,

G. PLETINCKX

[Dmitry Arefiev [da-soft.com]]

> Can I put a line of code in my program to modify this ? If yes, wich
> code?

You should execute command:
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. '

--
Dmitry Arefiev - www.da-soft.com
AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase
ASA, DbExpress, ODBC freeware data access engine
ThinDAC - multitier data access engine