Devart Forums

Hi,

I use DotConnect for Oracle (5.0.16.0) with direct="true". I've created a stored procedure with a parameter which is based on an Oracle type
( Create statement: create or replace type t_varchar1000_type is table of varchar2(1000);).
When I want to execute this procedure I get ORA-03115 (unsupported network datatype or representation).
In post http://www.devart.com/forums/viewtopic. ... t=ora03115 Paul remarks that in direct mode certain Oracle type are not supported. Is my user defined type not supported in direct-mode?
Is there a workaround for passing arrays to an Oracle stored procedure when using DotConnect for Oracle with direct=true?

Regards,

Matthieu de Graaf

Some types are not available in the Direct mode, like TABLE, OBJECT, ARRAY, REF, XML, BINARY_DOUBLE, BINARY_FLOAT. User defined types are not available.

Please refer to our online documentation to learn more about the limitations of the Direct mode: http://www.devart.com/dotconnect/oracle/docs/ , the Using dotConnect for Oracle part, the Using Direct Mode section.

Hi Shalex,

Thanks for your response. It's clear to me.

Being able to use simple array types (table of would be a huge improvement.
I'd like to submit this as an enhancement request.

Regards,

Matthieu de Graaf