64-bit Windows 8/7 32-bit PLSQL connection 64-bit Oracle11g

64-bit Windows 8/7 32-bit PLSQL connection 64-bit Oracle11g
64-bit Windows 8/7 32-bit PL/SQL connection 64-bit Oracle 11g

Note: Oracle's oci. dll is 64-bit after installation, while 32-bit application PL/SQL Developer cannot load

Solution
Step 1: Download the Instant Client for Microsoft Windows (32-bit) package address: http://www.oracle.com/technetwork/topics/winsoft-085727.html

Step 2: Decompress the file

Step 3: configure system environment variables
TNS_ADMIN = E: \ app \ xiaokui \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
(Note: The first half of NLS_LANG must be AMERICAN_AMERICA, Because instant client does not support other languages;
The latter half can be adjusted according to the character set of your database. If the database uses AL32UTF8, you can set AL32UTF8)

Step 4: Configure PL/SQL

Time: August 06, 2014

Speaker: xiaokui