Using DOA 4.0.6, Delphi 6.

What is the best way to indentify what version of the Oracle Client is in use at runtime?

I am looking at the booleans in OracleCI but don't see any 10g references in the help file. Are there any 10g changes in OracleCI? Would you consider it reliable to deduce the Oracle version based on the OCI functions available (ie, OCI80 but not OCI81 must mean Oracle 8.0.x installed)? Is there a way to get a more specific rev number out of OCI.DLL?

Direct Oracle Access does not use any 10g specific OCI functionality, so it is not explicitly detected. Other than that you can use the OCI70, OCI72, OCI73, OCI80, OCI81, OCI90 and OCI92 booleans. The expression (OCI80 and not OCI81) does indeed imply and Oracle 8.0.x client. OCI92 implies an Oracle Net 9.2 or 10g client.

I am using DOA 3.4, Delphi 5 and Oracle 9.2, it's works greatly.
I am migrating my database to Oracle 10.1.0.3, but when i execute my old application, i got the message "exception in module doa34d5.bpl at 00026DC4. A Query with LOB's requires OCI8 mode, but OCI7 mode is used". How can i resolve this problem.

10g support requires an upgrade to 4.0.

Is there any plan to at least add the check for 10g to the OracleCI unit? Currently, if there are two versions of the Client installed and I want to change to the 10g Client from the default 9x client, the only way to do it is to parse the values returned from the OracleCI.BuildOracleHomeList looking for 10g and then changing the OracleCI.OracleHomeName to the correct name.

Thanks
Richard Anderson

Direct Oracle Access uses the Primary Oracle Home by default, regardless of the version. The Primary Oracle Home is defined by Oracle as the one that is listed first in the PATH environment variable.