OK ...

I don´t understand your Q, very well.
The solution, is (in my way), use ADO and ADO Command Objects. Using this objects you probably can "capture" the output in a SP.
You must remember, in ORACLE, SP don't returns a rowset of data, (in SQL server, i.e., this is a posibility). the final results is an array, it is build from a cursor. And for each row in the result you should declare a cursor variable.

I have some examples if you want to check them.
for more info, http://www.msdn.com. Search fro : "Trips in ORACLE"

Good Luck.