LOBs

[kthomas]

I'm issuing a select statement against a table w/ a CLOB and BLOB field & am getting this error:

"A query w/ LOBs requires NET8, which is not detected on this PC."

To my knowledge, I have NET8 installed. I checked the Oracle installer which shows "NET8 client 8.0.5.0.0" and "OCI 8.0.5.2.0". My Session UseOCI7 property is false.

Any ideas?
Thanks,
-Kent Thomas

 

[Marco Kalter]

Perhaps Direct Oracle Access is not using the Net8 version you expected. Just call ShowDOAInfo(Session) for the TOracleSession you are using. This will display information about the Oracle Home, SQL*Net / Net8 DLL, and Oracle Server that is being used. Note that Direct Oracle Access will use the Primary Oracle Home by default. You can use the Oracle Home Selector (a standard Oracle utility) to select a different Primary Oracle Home.

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