I've an Oracle Stored Procedure which builds a Dynamic Table filled with calculated fields from other 'real' Tables. This data can be viewed in SQL*Plus, but is obviously removed from memory when the Procedure completes.

I now need to get this data back to VB (Access actually but the concept should be the same).

I don't want to build tables to store this dynamic data but would rather deal with a Recordset.

Is there any way to call the Oracle Stored Procedure from VBA and populate a Recordset?

ADO would be my prefered choice as I have an open connection in my app, but I don't know how to call the Stored Procedure in such a way that a Recordset is populated. Or how to return such a Recordset from the Oracle side.

Has anyone done something similar and can offer me advice?