OracleArray. How do I insert nulls?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
kevinherring
Posts: 64
Joined: Wed 04 Jan 2006 15:32

OracleArray. How do I insert nulls?

Post by kevinherring » Tue 17 Apr 2007 12:42

I have a procedure that I call using the CoreLab drivers that takes a VARRAY as an argument.

In my code I create the command object and the parameters, then I create an OracleArray object, and loop through my dataset (Decimals) and call array.add.

This all works fine until I get to a dbnull in my dataset, at which point I get an ArgumentException.

I tried the array.item(i) = value syntax, in the hope that I can just skip over the null value, leaving it as a 'nothing' but I get and argumentoutofrange exception.

How can I insert into nulls into my OracleArray?

Thanks
Kevin

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 17 Apr 2007 12:59

This problem should be fixed in OraDirect .NET 4.0 beta. Please check it out.

Post Reply