Windows x64 with 32-bit instant OCI.dll

[Tim Scott]

Hi,

I can get this to work almost completely nicely, but there's a small niggle that I can't quite pin down.

It seems that when using a "Tool" (Tools / Configure Tools ...") with an external programme (eg: 'cmd') PL/SQL Developer is setting ORACLE_HOME to the path to the oci.dll that I've configured, not to the path to the [64 bit] Oracle Database Home. If I don't have the sqlplus.exe in my instant client folder, then sqlplus at such a command prompt doesn't work because it can't find the message files.

I could add the instant client sqlplus, but then it complicates the "sqlplus / as sysdba" stuff because the sqlplus is not in the same Oracle Home.

I have tweaked the Tool to call a .bat file which sets the environment and then starts 'cmd', but it seems a bit convoluted.

Anyone else run into this ?
Any better ideas ?

Thanks,
Tim

 

[Marco Kalter]

PL/SQL Developer does not set ORACLE_HOME. If your tools require specific environment variables, you can set them in the params.ini file in the PL/SQL Developer installation directory. For example:

ENV:ORACLE_HOME=C:\Oracle\product\11.2.0\client_1