You can use VARRAY or TABLE data type to return result sets. I have addressed how to use them in one of my previous responses.
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.