Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_LANG....

439075Dec 15 2005 — edited Dec 15 2005
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2006
Added on Dec 15 2005
2 comments
907 views