In the past I've used pass-through queries with SQL Server stored procedures as record sources in access to return record-recordsets that could be used as recordsources for a form or report, etc:
I've tried doing this in Oracle and I can still fire off a stored procedure for the purposes of populating a table or updating a table like so:
BEGIN VALIDATION_TOOLS.SP_SETTLED_REBATES_TRIM_FIELDS('14-Aug-14'); COMMIT; END;
but I can't get it to return records like I can with SQL Server. The closest I can get is using a SYS_REFCURSOR to return a cursor I can loop through and see in the script output.
Can someone point me in the right direction to get the same functionality in Oracle that I have with SQL Server?