changing userenv('LANG')

[Pierre Maas]

to all,

When i do a "select userenv('LANG') from dual" I got the session NLS_LANGUAGE parameter, the value is different from the database or instance LANG parameter. Somewhere in PLSQL developer is for me a wrong NLS_LANGUAGE set. Do somebody know how to change this (not a change with "alter session set NLS_LANGUAGE='American' ".

Thanks in advance.
pjmaas

 

[Marco Kalter]

The language and territory are controlled by the NLS_LANG key in the Oracle Registry:

hkey_local_machine\software\oracle\\nls_lang = language_territory.charset

 

[Pierre Maas]

Thanks Marco,

It works now as usual !!

Prettig weekend.

Pierre Maas