DOA vs multiple Oracle registry root

[Tierry]

Hi,

I am wondering if DOA supports multiple registry roots. By default, DOA reads the Oracle registry root to locate the SQL*Net driver. In our development environment we have several versions of SQL*Net. So we have the root and also Home1 and Home2 from the Oracle registry which point to different SQL*Net versions. How I can configure DOA to point to this Home1 or Home2 Oracle directory registry ?

Thank you in advance for your help.

Tierry

 

[Marco Kalter]

At design-time you can select the correct Oracle Home through the Oracle > Preferences menu. This only affects connections made in the IDE.

At run-time you can set the OracleHomeName variable in the OracleCI unit before making a connection to the database. See the OracleCI topic in the Help file or User's Guide for more information.

 

[Tierry]

I am using C++ Builder. I have checked the user's guide but I haven't got detailed information on how to set the OracleHomeName at runtime. Could you send me an example in C++ Builder ?

Thank you in advance for your support.

Tierry

 

[Marco Kalter]

To set the Oracle Home to "OraHome92", set global variable OracleHomeName before making the first connection in your application:

OracleHomeName = "OraHome92";
MySession->LogOn();