Multiple Oracle Homes

[bmayfield]

We have need to run Oracle Forms 6i against an Oracle 8 client (has to use the version 8 OCI.DLLs) and we would like to run Delphi 2006 using your data connectors using the Oracle 10g client. Is there a way to tell Delphi to use a specific Oracle home so your data connectors use the 10g OCI.DLLs and not default to the Oracle 8 client that is specified by Oracle Home in the registry? The system path statement does not override the registry does it?

C:\>path
PATH=C:\Oracle10gClient\bin;C:\orant\bin;C:\Oracle9i\bin;C:\Program Files\Oracle
\jre\1.1.8\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\WINDOWS\system32;C:\WIND
OWS;C:\WINDOWS\System32\Wbem;C:\orant\jdk\bin;C:\Oracle9i\jdk\bin

Regard,
Bruce

 

[Marco Kalter]

Direct Oracle Access uses the Primary Oracle Home by default. This is the home that is listed first in the PATH.

 

[lecare039]

Take a look on the helpfile:

1. If already initialized then exit
2. Check if a OCIDLL= parameter is entered on the command line, skip to point 9
3. If the OCIDLL string has a value, skip to point 9
4. Check if a ORACLEHOME= parameter is entered on the command line, skip to point 7
5. If the OracleHomeName string has a value, skip to point 7
6. Determine the Primary Oracle Home
7. Check the registry to determine the ORACLE_HOME directory
8. Add

 

[Marco Kalter]

It's step 6:

6. Determine the Primary Oracle Home

This is the home that is listed first in the PATH.

 

[lecare039]

Ok, well and what if the path you got with step 7:

7. Check the registry to determine the ORACLE_HOME directory

is an other on? I've tested it now, and it seems that the one from 6 will be used, if one of the paths there direct to a oci.dll? After processing all paths in PATH and no dll was found , it seems step 7 will be done?
Maybe the doc has to be bit more specific.

 

[Marco Kalter]

6/7/8 are the same directory. If 6 fails, 7/8 fail as well.