Toad World® Forums

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

Please i need help. (I SEARCHED A lot and get more confused . )

I use Toad 9.7.25 and i made this procedure (in a package)

PROCEDURE ReportaCC(pfcorte IN DATE, lcursor IN OUT SYS_REFCURSOR)
IS
BEGIN
OPEN lcursor FOR
select c1, c3, c3 from table1 where hdate = pfcorte;
close lcursor;
END;
In toad’s sql editor i´d like execute that procedure and show the cursor results in toad’s datagrid:

— I WANT THE NEXT CODE CAN EXECUTE IN TOAD’S SQL EDITOR.

DECLARE
  PFCORTE DATE;
  LCURSOR SYS_REFCURSOR;
BEGIN

    PFCORTE := '31/08/2012';
    -- LCURSOR := NULL; -- Modify the code to initialize this parameter

    mypaq.REPORTACC( TO_DATE(PFCORTE,'DD/MM/YYYY') , LCURSOR );

    :to_grid := LCURSOR;

    COMMIT;

END;

When i execute the script (F9), and set the variable :to_grid type cursor, i get the next error:

“ORA-24338: statement handle not executed”

What can be the problem

Thanks in advance.