Toad World® Forums

How to display a sys_refcursor data in TOAD's Data Grid

Hi, everyone …

I created this function,


CREATE or REPLACE function ReportaCC(pfcorte IN DATE)
RETURN SYS_REFCURSOR
AS
lcursor SYS_REFCURSOR;
BEGIN
OPEN lcursor FOR
select c1, c3, c3 from table1 where hdate = pfcorte;
RETURN lcursor ;
END;
/


And execute as

select ReportaCC(sysdate) from dual

Then i double click “cursor” in datagrid to see the results.

And opens a windows with data… how can i save/export that to excel?

Thanks…