ORA-3115 - Unsupported network datatype or representation

trubin · Post by **trubin** » Wed 25 May 2011 23:25

Hi

Environment is Delphi 2007 for Win32, Oracle 11 r2 (windows server), dbexpoda v 4.90.

I am using dbexpoda40.dll, the TCRSqlConnection, EnableBCD is True and everything else seems to be fine.

This error happens when I try to add a BINARY_FLOAT field to the TSqlQuery columns. If I typecast it using TO_CHAR or TO_NUMBER, it works.

Any ideas?

Thanks in advance,
Tiago

AlexP · Post by **AlexP** » Thu 26 May 2011 07:59

Hello,

Unfortunately, for the time being such types as OBJECT, ARRAY, REF, XML, BINARY_DOUBLE, BINARY_FLOAT are not supported in the Direct mode. You should use the OCI mode to work with these types.

trubin · Post by **trubin** » Thu 26 May 2011 14:52

Sorry, forgot to mention that I am using the OCI mode.

Regards,
Tiago

AlexP · Post by **AlexP** » Fri 27 May 2011 06:41

Hello,

I cannot reproduce the problem in the OCI mode.
Please send us an example demonstrating the problem including scripts to create and fill the table to alexp*devart*com.