Forums Active Threads
Print Thread
NLS_LANG setting and OCI errors
#38730 09/10/10 04:16 PM
Joined: Apr 2004
Posts: 203
NYC, USA
RobertK Offline OP
Member
OP Offline
RobertK
Member
Joined: Apr 2004
Posts: 203
NYC, USA

Along with this post I have sent the elf file to support email

Client is Instant Client 10.2 (Basic Lite)
Just installed 8.0.4

When starting the app....first this:

[Linked Image]


so I did this:

[Linked Image]

re-logging in, got this:

[Linked Image]

re-logging in agin, got this:

[Linked Image]


Without adding the NLS_LANG I can connect with no problem.



Last edited by RobertK; 09/10/10 04:19 PM.
PlSQLDev Version 8.0.4
Oracle 11gR2
Re: NLS_LANG setting and OCI errors
RobertK #38731 09/11/10 10:21 AM
Joined: Aug 1999
Posts: 22,220
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,220
The NLS_LANG variable needs to be set to LANGUAGE_TERRITORY.CHARSET. For example: AMERICAN_AMERICA.UTF8

Marco Kalter
Allround Automations
Re: NLS_LANG setting and OCI errors
Marco Kalter #38732 09/11/10 09:22 PM
Joined: Apr 2004
Posts: 203
NYC, USA
RobertK Offline OP
Member
OP Offline
RobertK
Member
Joined: Apr 2004
Posts: 203
NYC, USA
thanks that fixes it

PlSQLDev Version 8.0.4
Oracle 11gR2

Moderated by  support 

Link Copied to Clipboard
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.025s Queries: 14 (0.006s) Memory: 2.5064 MB (Peak: 3.0430 MB) Data Comp: Off Server Time: 2024-05-20 02:46:28 UTC
Valid HTML 5 and Valid CSS