PLSQL uses 64-bit OCI. dll, while PLSQL uses 32-bit OCI. dll. An error occurs.
The solution is as follows:
1, to the Oracle official website to download Oracle instantclient (: http://download.oracle.com/otn/nt/instantclient/112010/instantclient-basic-win32-11.2.0.1.0.zip), my database installed is 11.2.0.1.0, so the download instantclient is also 11.2.0.1.0 version. Decompress the downloaded file to the installation directory of Oracle. For example, in the D: \ oracle \ product directory, there is also a folder 11.2.0, named instantclient ,, and add the directory to the system's environment variable path.
2. Open PLSQL and cancel logon.ProgramIn the preference, find connection settings, set ORACLE_HOME and oci_library, ORACLE_HOME to the path of the instantclient folder, and oci_library to the OCI. dll file under the instantclient directory. Disable PLSQL.
3. Copy the tnsnames. ora file in the dbhome_1 \ Network \ ADMIN directory to the instantclient directory and add tns_admin = D: \ oracle \ product \ 11.2.0 \ instantclient to the environment variable.
4. Open PLSQL again and display the previously configured Oracle service name in the database. PLSQL can be used normally.
Some people on the Internet still need to modify the registry or use bat to start PLSQL for Oracle character sets. This operation is not performed during my operations, and Chinese characters in the database can be used normally, it is estimated that the higher version of PLSQL solves the character set problem. I am using plsql9.