Unanswered: Returning multiple tables from a function
I have a SQL Server 2000 db that I am currently converting to Oracle 9. In the SQL Server db I have a number of procedures that return recordsets. In Oracle I believe the only way to do this is to build a pl/sql table in a function and return the table.
While somewhat laborious this method works apart from in one instance where the SQL Server procedure returns two recordsets.
Basically my questions are:
1. Is there a better way of returning a recordset from a function/procedure in Oracle?
2. Is it possible to return two recordsets from a function/procedure in Oracle?