DOA - Delphi errors with Oracle 21

[altink]

Hello

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

Error 1:
: Type mismatch for field '', expecting DateTime actual: WideString

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

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 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

 

[Marco Kalter]

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

 

[altink]

Thank You Mr. Kalter

Is DOA 4.1.4 a stable version?

Asking because on product pagehttps://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

 

[Marco Kalter]

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.

 

[altink]

Thank You very much Mr. Kalter

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

best regards
Altin

 

[Marco Kalter]

Yes, this will work fine.

 

[altink]

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