安裝完Oracle(64位)、PL/SQL Developer後運行PL/SQL出現如下的錯誤:
網上查資料說,我的PL/SQL DevelZ喎?http://www.Bkjia.com/kf/ware/vc/" target="_blank" class="keylink">vcGVy0+tPUkFDTEWyu7zmyN2jrLy0UEwvU1FMsrvWp7PWNjTOu7XET1JBQ0xFo6zS8rTLtcPPwtK7uPYzMs67tcRPUkNBTEW/zbuntsuyosXk1sPP4NOmtcSyzsr9o7o8L3A+Cgo8cD694r72sr3W6NChvMejujwvcD4KPHA+0ruhos/C1NhPUkFDTEUgMzLOu7/Nu6e2yzwvcD4KPHA+z8LU2LXY1rejumh0dHA6Ly93d3cub25saW5lZG93bi5uZXQvc29mdC8xMDI5MDIuaHRto6hPcmFjbGUgMTBnv827p7bLvqu88sLMyauw5qOpPC9wPgoKPHA+tv6hor3i0bm1vU9SQUNMRSCwstewxL/CvM/C0ru49r3QcHJvZHVjdLXExL/CvM/Co6yyotbYw/zD+9K7z8KjqMP8w/uyu8rHsdjSqrXEo6mjrM7SstnX97TLsr3Kx8P8w/vOqiBpbnN0YW50Y2xpZW50XzExXzI8L3A+CjxwPjxpbWcgc3JjPQ=="http://www.2cto.com/uploadfile/Collfiles/20140604/201406040858148.jpg" alt="\">
三、PL/SQL Developer配置,perference->Connection裡面設置OCI Library和Oracle_Home
ORACLE Home(empty is autodetect) :該選項配置ORACLE 客戶端的主目錄
OCI library(empty is autodetect) :給選項配置ORACLE客戶端目錄下oci.dll 的完整目錄
四、設置環境變量
對於NLS_LANG環境變量,
最好設置成和數據庫端一致, 首先從數據庫端查詢字符集信息:
SQL> select userenv("language') nls_lang from dual;
NLS_LANG
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
右擊"我的電腦" - "屬性" - "高級" - "環境變量" - "系統環境變量":
1>.點擊"新建", 變量名設置為"NLS_LANG", 變量值設置為"SIMPLIFIED CHINESE_CHINA.ZHS16GBK", 點擊"確定";
2>.新建環境變量“TNS_ADMIN”變量值為 “Oracle客戶端的主目錄”
在此我的配置是:“D:\app\Administrator\product\instantclient_11_2”
3>.最後點擊"確定"退出.
重啟PL/SQL Developer無問題!