After Oracle (64-bit) and PL/SQL Developer are installed, the following error occurs when PL/SQL is run:
My PL/SQL DevelZ databases? Http://www.bkjia.com/kf/ware/vc/ "target =" _ blank "class =" keylink "> vcGVy0 + release/release + 0 ruhos/C1NhPUkFDTEUgMzLOu7/release + release/CvM/Co6yyotbYw /zD + 9K7z8KjqMP8w/release/vOqiBpbnN0YW50Y2xpZW50XzExXzI8L3A + cjxwpjxpbwcgc3jjjpq = "http://www.2cto.com/uploadfile/Collfiles/20140604/201406040858148.jpg" alt = "\">
Iii. PL/SQL Developer configuration, set OCI Library and Oracle_Home in perference-> Connection
ORACLE Home (empty is autodetect): This option configures the Home Directory of the ORACLE client
OCI library (empty is autodetect): configure the complete directory of oci. dll in the ORACLE client directory for options
Iv. Set Environment Variables
For the NLS_LANG environment variables, it is best to set them to be consistent with the database. First, query the character set information from the database:
SQL> select userenv ("language") nls_lang from dual;
NLS_LANG
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Right-click "my computer"-"properties"-"advanced"-"environment variables"-"system environment variables ":
1>. Click "new", set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and click "OK ";
2>. Create an environment variable named "TNS_ADMIN" and set the value to "main directory of the Oracle client"
Here, my configuration is: "D: \ app \ Administrator \ product \ instantclient_11_2"
3>. Click "OK" to exit.
Restart PL/SQL Developer. No problem!