Page 1 of 1

ORA-3115 - Unsupported network datatype or representation

Posted: Wed 25 May 2011 23:25
by trubin
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

Posted: Thu 26 May 2011 07:59
by AlexP
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.

Posted: Thu 26 May 2011 14:52
by trubin
Sorry, forgot to mention that I am using the OCI mode.

Regards,
Tiago

Posted: Fri 27 May 2011 06:41
by AlexP
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.