Using VARRAY type with DataReader component

Leonid · Post by **Leonid** » Tue 04 Jul 2006 15:52

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

Paul · Post by **Paul** » Wed 05 Jul 2006 06:57

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

Leonid · Post by **Leonid** » Wed 05 Jul 2006 07:03

You are absolutly right. That is the reason. Thanx a lot.

Alexey · Post by **Alexey** » Wed 12 Jul 2006 07:20

You are welcome.