Let''s start by saying this: "it is possible to retrieve Recordsets from an Oracle stored procedure." Try doing a web search along the lines of "recordset oracle stored procedure" and you''ll probably find there aren''t manner accurate or complete examples of how this is done.
