ORA-12705: invalid or unkown NLS parameter value specified

Having trouble installing Oxygen? Got a bug to report? Post it all here.
blcaya
Posts: 7
Joined: Thu Aug 11, 2005 9:08 pm

ORA-12705: invalid or unkown NLS parameter value specified

Post by blcaya »

I am attempting to make a connection to my Oracle database through the File ->Import ->Database data option.

I receive the following error:

ORA-12705: invalid or unkown NLS parameter value specified

I understand the NLS settings but am not sure why this is being thrown? I have only two NLS parameters set on my local machine, NLS_LANG and NLS_DATE, that I'm aware of. Do I need other's set for your tool? Any help would be greatly appreciated.

Thanks in advance!
blcaya
Posts: 7
Joined: Thu Aug 11, 2005 9:08 pm

Post by blcaya »

Some additional information on the nls parameters I have set: :D

SQL> select * from nls_session_parameters;

PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT MM/DD/YYYY
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM

PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY

15 rows selected.
stefan

Post by stefan »

This is most likely caused by a misconfiguration of the Oracle NLS parameters (for example the NLS_LANG environment variable contains an invalid language, territory, or character set).
You try to remove the environment variable NLS_LANG. Then log again.
blcaya
Posts: 7
Joined: Thu Aug 11, 2005 9:08 pm

Post by blcaya »

Stefan,

A million thanks! You were right on. I had a newer version of the Oracle jdbc driver(10g). I pointed to a file a couple of versions(9i) old and it works like a charm. Appreciate the support!
Post Reply