Page 1 of 1

Using VARRAY type with DataReader component

Posted: Tue 04 Jul 2006 15:52
by Leonid
Hi. I have downloaded the trial version of OraDirect .NET components and I am trying to work with them. While running your demo of using the VARRAY type with the DataReader component, I receive an error message: "Data type is not supported" when clicking the Execute button in the demo. The error occurs on the execution command:
CoreLab.Oracle.OracleDataReader dataReader = oraCommand.ExecuteReader();
where oraCommand.Text is "SELECT * FROM ARRAYTABLE"

We need this feature in our development, and we especially need to transfer the array type to stored procedure parameters. But this doesn't work either. So I need some way to solve this problem and check that everything works fine. This is the last thing that prevents us from purchasing your product

Posted: Wed 05 Jul 2006 06:57
by Paul
Probably your ConnectionString includes Direct=true (connection without Oracle client). OraDirect .NET does not support VARRAY and OBJECT types in direct mode. See OraDirect .NET documentation

Posted: Wed 05 Jul 2006 07:03
by Leonid
You are absolutly right. That is the reason. Thanx a lot.

Posted: Wed 12 Jul 2006 07:20
by Alexey
You are welcome.