disconnected recordset from stored proc to VB

How can a function returning a recordset to a VB class be a disconnected recordset. I am successful in making the recordset being returned but i have to make it connectionless and set the
cursorLocation to aduseClient in VB and
activeConnection to Nothing.
But since the recordset is returned by An Oracle Stored Proc I get the message "Operation is not allowed when the object is open" if i try to set the property later.

please help

Thanks.
TO.