Devart Forums

Posted: **Thu 10 May 2012 19:10**

Hi all,

I have a problem with ODAC 8.1.6
I'm using direct connection to my database (Oracle 11g).

I have a query with this code:

Code: Select all

select myFunction('PARAMETER1', 'PARAMETER2') as result from dual

"myFunction" returns a cursor.

When I try to open the query, this error occurs: "Data type is not supported".
If I do not use direct connection, the error does not happen. It works perfectly.

What am I doing wrong?

TIA,

Rafael Garcia

Posted: **Fri 11 May 2012 12:39**

Hello,

Such Oracle types as OBJECT, ARRAY, REF_CURSOR, XML, BINARY_DOUBLE, BINARY_FLOAT are not supported in the Direct mode.
You can find more detailed information in the ODAC help, the Connecting in Direct Mode topic.
We plan to add the possibility of working with these types in the Direct mode in the future.

Devart Forums

Direct connection and cursor error.

Direct connection and cursor error.

Re: Direct connection and cursor error.