[
From Builder UK]
The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It's a bit trickier to go in the other direction. I've seen a lot of requests for help from developers looking for a way to pass an array of values to a PL/SQL stored procedure.
The article continues at
http://uk.builder.com/0,39026540,39293140,00.htm