Issue: PLD uses wrong OCI.DLL/ORACLE_HOME

[CTzen]

Marco,

I have Oracle9i Client and Oracle XE Server installed. Usually, I use Client ORACLE_HOME, but today I was checking 10G quoting and selected XE. But even after I restarted PLD, it is still using oci.dll from 9i ORACLE_HOME.

...\Slava\default.ini

[Preferences]
OpenTransaction=2
SelectedHome=XE

Debug.txt

2006-07-07 11:39:20  SessionChanged
                     OracleHomeKey: SOFTWARE\ORACLE\HOME0
                     OracleHomeDir: d:\oracle.2.0\client
                     Found: oci.dll
                     Using: d:\oracle.2.0\client\bin\oci.dll

Other info

PL/SQL Developer
  Version 7.0.2.1079 (MBCS)
  01.xxxxx - 10 user license
  Windows XP version 6.0 (build 2600) Service Pack 1

  Physical memory : 2,088,296 kB  (1,252,348 available)
  Paging file     : 4,030,884 kB  (2,734,968 available)
  Virtual memory  : 2,097,024 kB  (2,025,532 available)

Parameters
  C:\apps\PLSQLDeveloper\plsqldev.exe
  /debug

Preferences
  Session mode: Multi
  OCI Library:
  Use OCI7: False

Preference Files
  C:\apps\PLSQLDeveloper\Preferences\Default\Default.ini
  C:\apps\PLSQLDeveloper\Preferences\Slava\default.ini

Plug-Ins
  *FTP File Interface 2.0.7 (C:\apps\PLSQLDeveloper\PlugIns\ftp.dll)
   (* is Active)

Aliases
  ...

Homes
  OracleClient920  (d:\oracle.2.0\client)
  XE  (D:\oracle\app\oracle\product.2.0\server)

DLLs
  d:\oracle.2.0\client\bin\oci.dll

TNS File
  d:\oracle.2.0\client\Network\Admin\tnsnames.ora

Using
  Home: OracleClient920
  DLL: d:\oracle.2.0\client\bin\oci.dll
  OCI: version 9.2
  Oracle Database 10g Express Edition Release 10.2.0.1.0
  Character size: 4 byte(s)

 

[Marco Kalter]

What happens if you specify it on the command line?

plsqldev.exe oraclehome=xe

 

[CTzen]

Then it works, PLD picks up oci.dll from XE Oracle Home.