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
Limitations of direct mode
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.
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.
-
- Posts: 18
- Joined: Wed 14 May 2008 12:13