PL/SQL Developer Initialization error

oracle plsqldeveloper
chohyunwook picture chohyunwook · Mar 10, 2017 · Viewed 33.7k times · Source

I want use PL/SQL Developer

first my oracle directory

C:\oracle\product\10.2.0\client_1\BIN

I use windows10 and environment variable setting

ORACLE_HOME C:\oracle\product\10.2.0\client_1

Path C:\oracle\product\10.2.0\client_1\BIN but execute Initialization error.

Initialization error
Could not load "C:\oracle\product\10.2.0\client_1\bin\oci.dll"

OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home1
OracleHomeDir: C:\oracle\product\10.2.0\client_1
Found: oci.dll
Using: C:\oracle\product\10.2.0\client_1\bin\oci.dll
LoadLibrary(C:\oracle\product\10.2.0\client_1\bin\oci.dll) return 0

Answer

honglin zhang picture honglin zhang · Dec 28, 2017

steps:

  1. download oracle instant client (64 bits for latest version of PL/SQL; 32 bits for old version)
  2. extract to a folder. for example: c:\oracle\instantclient
  3. open PL/SQL developer--> Configure-->Preferences--> Oracle Connection
  4. under OCI library, keyin OCI.DLL file path in the text box: c:\oracle\instantclient\oci.dll
  5. click OK and restart PL/SQL

done

Related questions

How to test an Oracle Stored Procedure with RefCursor return type?

I'm looking for a good explanation on how to test an Oracle stored procedure in SQL Developer or Embarcardero Rapid XE2. Thank you.

Read More
How to connect to remote Oracle DB with PL/SQL Developer?

I have a database "TEST", to which I connect at address 123.45.67.89:1521. How do I connect to it using PL/SQL Developer?

Read More
how to convert a string date to date format in oracle10g

My date value is stored as varchar2 and the value is 15/August/2009,4:30 PM, how to convert this to a proper date format like DD-MM-YYYY.

Read More