OracleArray. How do I insert nulls?
Posted: 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
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