Pass array to pl/sql procedure using .NET OracleClient

[Ian Cox]

I am trying to pass an array to an oracle procedure using the
OracleClient for .NET. I can't find away to do this/ I have trawled
the net and have found a few people trying to do the same thing but no
solution. The only solution given was to pass the array as a delimited
string, but this is no good for my purposes as the array could get
quite large.

Thanks in advance for any suggestions
Ian

 

[Bob Beauchemin]

You can't. VARRAY, OBJECT, and embedded tables aren't supported in
OracleClient for .NET, ODP.NET, or DataDirect that I'm aware of. You can
write your provider vendor and request it. ;-) In ODP.NET, you can pass in
every parameter as an array value, this implements multiple parameter sets
(not varrays). Conceivably, you might be able to do this using OO4O and COM
interop.

Bob Beauchemin
http://staff.develop.com/bobb

 

[Ian Cox]

Ah, I thought that might be the answer. That's a shame because now I'm
going to have to come up with a completely different solution (probably
involving using a local database with a link to the remote database I
need to pass the array to - still figuring that one out). Maybe I'll
just write my own provider, er no then again maybe not.
Still, thanks for the quick and useful response.

Cheers
Ian