Hi,

We are using Delphi XE2 and DOA 4.1.3.1 and are facing error: "A query with LOB's requires OCI8 mode, but OCI7 mode is used".

Is there a fix for this version available?
I read on the forum that it is fixed in 4.1.4 but i don't see a download for XE2 for that version.


Kind regards

Ruud

Can you let me know your Oracle Server version?

Hi Marco,

It's Oracle database 21c Enterprise Edition Release 21.0.0.0.0.- Product version 21.3.0.0.0

Thanks in advance for looking in to this,

kind regards

Ruud

For Oracle21c Support you would indeed need to update to 4.1.4, and this would require an upgrade to Delphi 10.x or 11.x.

Hi Marco,

not the answer i was hoping for.
This would be a major investment in multiple components and a lot of work.
No workaround? Is this the only issue with 21c or is there more that you know of?

Can you give some insight of the root/cause of this problem?
Do you know of a setting in Oracle to make it downward compatible?

Kind regards
Ruud

Okay. If you send and e-mail to support@allroundautomations.com we'll arrange something.

There is not setting in Oracle to resolve this.