Problems with Oracle database using PLSQL (64-bit)

64-bit win7 with PL/SQL, often meet "Could not load" ... \bin\oci.dll "" This error, I checked the information because PL/SQL only supports 32-bit OS, The workaround is to load an additional Oci.dll file with the following actions:

STEP1:

Download the Oci.dll package "Instantclient_10_2" to the following address and unzip the file to "D:\Program files \"

http://download.csdn.net/detail/shenkxiao/4181424

STEP2: Install the Oracle client, and with TNS, start PL/SQL, click the " Cancel" button in the login, do not log directly into the PL/SQL Operation interface, click " Tools " under " preferences " as follows:

Step3: Select the Oci.dll file in the STEP1 directory, click " confirm ", such as:

Step4: login Page Enter the IP in TNS in the " database " option : Port/DB instance ( tested, this must be written here, otherwise not properly connected)

Problems with Oracle database using PLSQL (64-bit)