NLS_LANG....
439075Dec 15 2005 — edited Dec 15 2005Hi All,
I´m having some problems with different versions of oracle clients.
My oracle database version is 9.2.0.4.0 and we have two versions of clients, one is english and other is portuguese( here, we´re having some problems).
When I´m connected in portuguese version, I tried:
SQL> alter session set NLS_LANG = 'AMERICAN_AMERICA.WE8MSWIN1252';
alter session set NLS_LANG = 'AMERICAN_AMERICA.WE8MSWIN1252'
*
ERRO na linha 1:
ORA-00922: missing or invalid option
In other hand, I tried:
In my windows 2k workstation, I tried to change this key:
For Oracle Database versions 8, 8i and 9i:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx\
where "x" is the unique number identifying the Oracle home.
HOME0 is the first installation
Old value - BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252,
New value - AMERICAN_AMERICA.WE8MSWIN1252.
When I log on sqlplus again, everything works fine. But I would like to do this in a sqlplus session, like I tried above.
Connected to sqlplus, is it possible to change this parameter NLS_LANG?
Anybody have an idea, how can I solve this issue?
Thanks for All,
Marcello.