Is there a way to cast a sys_refcursor to a table or xml table or other simple structure I can easil
I'd like a simple way to access a sys_refcursor. Below is some examle code. I call a function which returns a sys_refcursor. The return contains 0 or 1 rows with many columns. I need access to only 2 columns. Those 2 columns are always present if a row is returned and the name is consistent.
All this is to ask, is there a way to cast a sys_refcursor to a table or xml table or other simple structure I can easily access?
declare
cursor c1 is select fileid
from tbl1
where rtype in ('A','Q','R');
--
l_fileid number(10);
cRefRep sys_refcursor;