Please read my latest post and learn why you should include Pipelined Table Functions in your APEX developer toolbox #orclAPEX

https://blog.cloudnueva.com/apex-and-pipelined-table-functions