changing decimal character on windows

From: Bengali <ldewavrin_at_nerim.net>
Date: Wed, 6 Nov 2002 16:31:17 +0100
Message-ID: <aqbcaa$206i$1@norfair.nerim.net>

Hi,
i am running Oracle Database 9.2.0 on Windows 2000 ( French Language). I'd like to permanatly change the decimal character of my oracle instance from ',' to '.' .

As suggested in documentation, i added to %ORACLE_BASE%/admin/%ORACLE_SID%/pfile/init.ora.972002192319 the following initialization parameter : NLS_NUMERIC_CHARACTERS = ",. "

But it doesn't seem to take affect after the database restart.

I don't understand why?
When i type in sqlplus 'show parameter NLS_LANGUAGE' i get:

nls_language                         string      AMERICAN



'show parameter NLS_TERRITORY'

nls_territory                        string      AMERICA



'show parameter NLS_NUMERIC_CHARACTERS'

nls_numeric_characters               string

Am i proceeding the right way?
-I also changed Windows locale from french to English ( United States) but i get
the same decimal character ( i.e ,).
- I created the database with the "database configuration assistant".

Thanks in advance,
Luc Received on Wed Nov 06 2002 - 09:31:17 CST