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

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
lunr
Posts: 5
Joined: Mon 04 Dec 2006 13:08

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

Post by lunr » Thu 14 Dec 2006 07:45

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.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 14 Dec 2006 12:52

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.

Post Reply