Direct connection and cursor error.

[rafaelbg]

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

[AlexP]

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.