ORA-3115 - Unsupported network datatype or representation

ORA-3115 - Unsupported network datatype or representation

Postby 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
trubin
 
Posts: 6
Joined: Wed 25 May 2011 23:13

Postby 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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Postby trubin » Thu 26 May 2011 14:52

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

Regards,
Tiago
trubin
 
Posts: 6
Joined: Wed 25 May 2011 23:13

Postby 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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle