Different behavior locating OCIDLL

[Greg Stevenson]

Came up with a case where DOA 3.4.5 raises and error in trying to locate the OCI DLLs but PL/SQL Developer overcomes the issue sucessfully. Its a case where there is more than one home and the home that is selected (because its first in "the path") is not valid. Looking at the code in OracleCI.pas, it does not appear that the current routines make use of either DEFAULT_HOME or LAST_HOME. Does PL/SQL Developer use a different routing to locate the DLLs or is it using code later then 3.4.5?
--Greg

 

[Marco Kalter]

In PL/SQL Developer you can set a preference which Oracle Home you want to use. Furthermore it will preferably not use Net8 8.0.4. This is the main difference with Direct Oracle Access.

Both use the Primary Oracle Home by default. This is the Oracle Home that occurs first in the PATH environment variable. You can set it with the Oracle Home Selector (a standard Oracle utility).

------------------
Marco Kalter
Allround Automations