Page 1 of 1

OracleArray. How do I insert nulls?

Posted: Tue 17 Apr 2007 12:42
by kevinherring
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?


Posted: Tue 17 Apr 2007 12:59
by Alexey
This problem should be fixed in OraDirect .NET 4.0 beta. Please check it out.