Start with solving this:
Andrew Devenish-Meares wrote:
I am having issues finding information on how I could write PLSQL to return a set of results (rather than a single result).
You have two methods:
- Your OUT parameters need to return a COLLECTION.
- If not, it needs to return something that understands "multiple results" (ex XMLType)
- rewrite it as a PIPELINED FUNCTION
- this could be a "wrapper" that calls (1) or (2) but returns the values as a Pipelined function
At the very least, I like creating a PIPELINED FUNCTION because you can then use it in SQL.