Page 1 of 1
ORA-12705: invalid or unkown NLS parameter value specified
Posted: Thu Aug 11, 2005 9:28 pm
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!
Posted: Thu Aug 11, 2005 10:02 pm
by blcaya
Some additional information on the nls parameters I have set:
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.
Posted: Fri Aug 12, 2005 6:01 pm
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.
Posted: Fri Aug 12, 2005 7:58 pm
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!