What you need is a collection either index-by table, nested table or a VARRAY depending on your record set. Create your collection using CREATE TYPE, define your record set variable, fetch it using BULK COLLECT and return it as that TYPE. Then you can pass that record set to another procedure, report etc.,