You could try using
select * from table(xmlsequence( myfunc() )) to get xml in columns
or this example
select extractvalue(COLUMN_VALUE ,'/ROW/COL') from table( xmlsequence( cursor( select 1 COL from dual union all select 2 COL from dual) ))
to extract field COL. Here cursor(..) is equivalent of refcursor function
ps. note about xml overhead
pps. sorry if something wrong because this is my 1st post at this site