Print Thread
OracleCI Unit and Oracle Versions
#7209 02/22/05 03:37 AM
Joined: Jul 2003
Posts: 5
M
Member
OP Offline
Member
M
Joined: Jul 2003
Posts: 5
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?

Re: OracleCI Unit and Oracle Versions
#7210 02/22/05 10:41 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
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.


Marco Kalter
Allround Automations
Re: OracleCI Unit and Oracle Versions
#7211 03/16/05 09:53 AM
Joined: Mar 2005
Posts: 2
Jakarta - Indonesia
A
adi Offline
Member
Offline
Member
A
Joined: Mar 2005
Posts: 2
Jakarta - Indonesia
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.

Re: OracleCI Unit and Oracle Versions
#7212 03/16/05 10:08 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
10g support requires an upgrade to 4.0.


Marco Kalter
Allround Automations
Re: OracleCI Unit and Oracle Versions
#7213 07/31/07 03:51 AM
Joined: Apr 2004
Posts: 8
San Antonio, TX
H
Member
Offline
Member
H
Joined: Apr 2004
Posts: 8
San Antonio, TX
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

Re: OracleCI Unit and Oracle Versions
#7214 07/31/07 09:41 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
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.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.031s Queries: 14 (0.008s) Memory: 2.5164 MB (Peak: 3.0392 MB) Data Comp: Off Server Time: 2024-03-28 13:30:44 UTC
Valid HTML 5 and Valid CSS