ORA-12705 invalid or unknown NLS parameter value specifiedCause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command,
But could you tell me how to correct the syntax and nls_lang environment.
修改HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ORACLE\HOME0下的
NLS_LANG为…….你的字符集。
前面的不用变,关键是后面的,一定要写你的字符集,但现在可能不知是什么东西,oracle不认识
看有人说改成SIMPLIFIED AMERICA_CHINA.ZHS16GBK
或AMERICAN CHINESE .ZHS16GBK,这些代表什么意思呢?
select userenv('language') from dual去查询
你要么把查询出来的整个串复制给NLS_LANG算了
或AMERICAN CHINESE .ZHS16GBK这两个东西
这个
SIMPLIFIED CHINESE_CHINA.ZHS16GBK是正确的,你的nls_lang是这个吗?
把结果贴出来,帮你分析一下,到底是哪个不对