NLS_LANG setting with instant client - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer NLS_LANG setting with instant client

Print Thread

NLS_LANG setting with instant client #44514 09/05/12 01:13 PM
Joined: Nov 2003 Posts: 35 F FrankMUC OP Member
OP FrankMUC Member F Joined: Nov 2003 Posts: 35	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

Re: NLS_LANG setting with instant client FrankMUC #44516 09/06/12 09:47 AM
Joined: Aug 1999 Posts: 22,208 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,208	You will need to set NLS_LANG as an environment variable when using the Instant Client. Marco Kalter Allround Automations

Re: NLS_LANG setting with instant client Marco Kalter #44566 09/14/12 03:59 PM
Joined: Nov 2003 Posts: 35 F FrankMUC OP Member
OP FrankMUC Member F Joined: Nov 2003 Posts: 35	thanks

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.081s Queries: 15 (0.018s) Memory: 2.5011 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-04 19:55:02 UTC
Valid HTML 5 and Valid CSS