If you execute SP in the Oracle client and got the error like this:

oracle.xdo.XDOException: ? oracle.xdo.XDOException: ? oracle.xdo.dataengine.datasource.plugin.DataAccessException: ? java.sql.SQLException: ORA-06502: PL/SQL: ??°?-—??–?€?é”?èˉˉ : character string buffer too ? small ORA-06512: ??¨ ? "FAISOWNER_SIT.PROFITLOSSREP_DG_PACK", line 1007 ORA-06512: ??¨ ? "FAISOWNER_SIT.AMRETURNREP_DG_PACK", line 810 ORA-06512: ??¨ ? "FAISOWNER_SIT.AMRETURNREP_DG_PACK", line 1058 ?

?

Maybe it’s the language problem.

?

Execute this SQL:

??????????????? select userenv('language') from dual

???????????????

??????????????? if is SIMPLIFIED CHINESE_CHINA.ZHS16GBK, need to change “AMERICAN_AMERICA.AL32UTF8”.

?

open regedit Commend,

find path “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraClient11g_home1”

??????????? find the key is “NLS_LANG”, change name is “AMERICAN_AMERICA.AL32UTF8”

?

In the CMD window:

C:\Users\>set NLS_LANG=AMERICAN_AMERICA.AL32UTF8 ? C:\Users\>echo %NLS_LANG% AMERICAN_AMERICA.AL32UTF8 ? C:\Users\>"C:\Users\software\Toad ? for Oracle 10.6\Toad.exe" ?

轉載于:https://www.cnblogs.com/IcanFixIt/p/4253065.html

總結

以上是生活随笔為你收集整理的Oracle Client Language Problem的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。