Using VARRAY type with DataReader component

Using VARRAY type with DataReader component

Postby 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
Leonid
 
Posts: 24
Joined: Wed 26 Oct 2005 12:59

Postby 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
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Postby Leonid » Wed 05 Jul 2006 07:03

You are absolutly right. That is the reason. Thanx a lot.
Leonid
 
Posts: 24
Joined: Wed 26 Oct 2005 12:59

Postby Alexey » Wed 12 Jul 2006 07:20

You are welcome.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle