Save as xml the result of a cursor - dbms_xmlgen.getxml

select dbms_xmlgen.getxml('select reports.rep1(-1, null, ''01-01-2000'', ''01-04-2001'', null, null, null) from dual') xml from dual

 reports.rep1 returns an oracle cursor