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 ...

You might often want to validate parameters in your methods to ensure they have valid data. Most importantly, you might often want to protect your publicly exposed API methods by ensuring that the ...