topic Re: Unable to connect to TOAD /PLSQL developer in Operating System - HP-UX

Unable to connect to TOAD /PLSQL developer

satesh — Tue, 05 Sep 2006 10:57:59 GMT

Hi
I am able to connect SQL Plus but unable to connect TOAD /PLSQL developer getting error msg
ORA-12705: Invalid or unknown NLS parameter value specified

Re: Unable to connect to TOAD /PLSQL developer

Jonathan Fife — Tue, 05 Sep 2006 11:06:27 GMT

I would guess that your NLS_LANG environment variable isn't set correctly. If you're running SQL Developer from Windows I believe this is a registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and various subdirectories from there.

Re: Unable to connect to TOAD /PLSQL developer

dineshkumarv — Tue, 05 Sep 2006 14:55:39 GMT

Hi satesh

kindly make sure whether ur plsql dev or toad using the same oracle home which is used by ur sqlplus/oracle client

with regards
Dinesh

Re: Unable to connect to TOAD /PLSQL developer

Sean Dale — Tue, 05 Sep 2006 16:13:19 GMT

I set the NLS_LANG parameter as a system environment variable and everything works fine on my computer.

Re: Unable to connect to TOAD /PLSQL developer

Yogeeraj_1 — Wed, 06 Sep 2006 02:19:44 GMT

hi,

do you have several oracle homes on the client?

If yes, on the connect window, click on the "SQL*Net Help" button and set the appropriate "TOAD" home.

hope this helps!

yogeeraj

Re: Unable to connect to TOAD /PLSQL developer

Frank de Vries — Thu, 07 Sep 2006 03:31:11 GMT

It means only one thing:

You need to specify the NLS_LANG parameter.
Possible values are:
AMERICAN_AMERICA.WE8ISO8859P1

Now if you are not sure about which ORACLE_HOME then add them in your registry
for each ORACLE_HOME
thus: start run: type regedit
HKEY_LOCAL_MACHINE\software\oracle
Edit new string value NLS_LANG
value AMERICAN_AMERICA.WE8ISO8859P1
and the same for each ..\HOME0
..\HOME1 etc..

ALso if you have an older TOAD you may add
under controlpanel system environment variable set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
But that only makes sense if your ORACLE_HOME is in the %PATH% variable and
ORACLE_HOME is set.

But I would try the registry first.