DataType Unknown with Oracle Drivers

Data Abstract
1

RODA Gurus,

I am attempting to convert a Delphi Schema that was built using the ODAC driver. When I convert to the ODP10g.NET, ODP12c.NET, or ORACLE.NET drivers and attempt to open a given query on the client, it complains about "Unsupported DataType ‘unknown’ "

Again, this is the SAME schema used within Delphi against ODAC. After further digging it appears that the Oracle .NET drivers cannot interpret how the schema auto creates the parameters and uses the data type of “unknown”.

Is this something that can be addressed, so that the same drivers an interpret the “unknown” parameters the same. Ideally as it does with ODAC.

Regards,
Monte Carver

2

Hello Monte.

Unfortunately, I can’t reproduce the problem locally. Could you provide DataTable definition to reproduce problem and provide a solution? Also, can you change data type manually in the .daSchema file, recreate XSD or Table Definitions file and check is client able to get result correctly.

Thanks in advance.