Page 1 of 1

"data type is not supported" when trying to return an array from oracle

Posted: Thu 14 Dec 2006 07:45
by lunr
i have a stored function which returns an array, and i use it in a query, for example
select array_returning_function() from dual

this runs fine, until i set orasession.net to true. when try to execute it, i get an exception "data type is not supported" .

What is the cause and solution to this problem? Thanks in advance.

Posted: Thu 14 Dec 2006 12:52
by Plash
With the Net option set to True object and collection types are not supported. If you need to work with such types you should set the Net option to False.