NLS_LANG setting with instant client - 09/05/12 01:13 PM
Hi,
PL/SQL Developer 8.0.4.1514 works fine with the exception of the error message "NLS_LANG is not defined on the client ..." during start-up. As SQL*Net layer the Oracle Instant Client 11.2.0.3.0 32bit is used. It was not installed with OUI but extracted and copied only into a separate folder. TNS_ADMIN and NLS_LANG are defined as a System Environment Variable (Windows Server 2008 R2). Additionally NLS_LANG was defined in the registry under key HKLM\SOFTWARE\Wow6432Node\ORACLE.
"Oracle Home" and "OCI Library" are defined explicitly in Preferences->Oracle->Connections to point to the InstantClient directory and its oci.dll.
Help->SupportInfo->Registry shows SOFTWARE\ORACLE
(in red) and the NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
Any suggestions how to define NLS_LANG when using Instant Client?
Regards
Frank
PL/SQL Developer 8.0.4.1514 works fine with the exception of the error message "NLS_LANG is not defined on the client ..." during start-up. As SQL*Net layer the Oracle Instant Client 11.2.0.3.0 32bit is used. It was not installed with OUI but extracted and copied only into a separate folder. TNS_ADMIN and NLS_LANG are defined as a System Environment Variable (Windows Server 2008 R2). Additionally NLS_LANG was defined in the registry under key HKLM\SOFTWARE\Wow6432Node\ORACLE.
"Oracle Home" and "OCI Library" are defined explicitly in Preferences->Oracle->Connections to point to the InstantClient directory and its oci.dll.
Help->SupportInfo->Registry shows SOFTWARE\ORACLE
(in red) and the NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
Any suggestions how to define NLS_LANG when using Instant Client?
Regards
Frank