Limitations of direct mode

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
matthieu de graaf
Posts: 18
Joined: Wed 14 May 2008 12:13

Limitations of direct mode

Post by matthieu de graaf » Mon 09 Feb 2009 12:12

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 09 Feb 2009 16:25

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.

matthieu de graaf
Posts: 18
Joined: Wed 14 May 2008 12:13

Post by matthieu de graaf » Tue 10 Feb 2009 07:03

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

Post Reply