I'm stuck trying to loop through an xml query cursor
I have something like....
cursor c_records
is
select (xmlelement("item",
.....
) as "items"
from table x
where.....
Now I would like to loop through my xml records but I'm having a hard time and display them using dbms_output.put_line() but i'm having a hard time.
Any suggestions?
Thanks