Description of Retrieving Recordsets From an Oracle Stored Procedure :
This article is mostly helpful for database managers which guides them how to access data from Oracle database using stored procedures. This tutorial briefly gives instruction about how to call the stored procedure from ADO, how to populate the stored procedure output parameters with data, PL/SQL tables etc.,