Hello

I do use a registered DOA version in my Delphi application, and do experience errors with Oracle 21.

Error 1:
<TOracleDataset name>: Type mismatch for field '<field_name>', expecting DateTime actual: WideString

The <field_name> is a TIMESTAMP(6) in a table that also has three CLOB fields.
Happens when I query from my Delphi application:
select <field_name>, field2, field3, .... from <my_table>

Error 2:
A query with LOB's requires OCI8 mode, but OCI7 mode is used

Happens when I query the same table from my Delphi application:
select t.* from <my_table> t where t.rowid = chartorowid ....

DOA version:
4.1.3.5
Oracle Client:
11 and 19 (both 32 bit) - have not tried others
Oracle DB version:
21.3.0.0.0
Delphi:
10.1 (Berlin)

At your disposal for further info

Please advise

best regards
Altin

Both errors have the same cause. You will need to update to Direct Oracle Access 4.1.4 for Oracle21c compatibility.

Thank You Mr. Kalter

Is DOA 4.1.4 a stable version?

Asking because on product page
https://www.allroundautomations.com/products/direct-oracle-access/

... under "System requirements", I read:
"The supported Oracle Server versions are 7.x, 8.x, 8i, 9i, 10g, 11g, 12c, 18c and 19c on any platform."

No mention of Oracle 21.

And also:
"Direct Oracle Access is available for all recent versions of Delphi"

Is Delphi 10.1 Berlin supported?

best regards
Altin

We'll update the system requirements!

Oracle 21c and 23c are supported by 4.1.4, which is indeed a stable version. All RAD Studio versions up to version 12 are supported, including 10.1.

Thank You very much Mr. Kalter

One last question:
Does DOA 4.1.4 supports Oracle 10g release 2 ?

best regards
Altin

Yes, this will work fine.

Thank You very much Mr. Kalter

For sure I will buy and upgrade to DOA 4.1.4. Can't think of working Delphi->Oracle without it.
Same for PL/SQL Developer.

Keep the great job

best regards
Altin