If the function MY_FUNC returns an object table then you can do it.

Check out the following article from Oracle Magazine. It should give the information that you need....

http://www.oracle.com/oramag/webcolu...y_dynamic.html

I hope that helps.