Edit Question - KnowledgeHub

Title Body

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 THIS 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. Thanks four your posts... worked fine! But now have another question... If i replace the simple query (select c1, c2, c3 from table...) for a mor complex like this: PROCEDURE ReportaCC(pfcorte IN DATE, lcursor OUT SYS_REFCURSOR) IS BEGIN OPEN lcursor FOR SELECT ENC.CVEOTORGANTE, ENC.NOMBREOTORGANTE, ENC.IDENDINTIFICADORDEMEDIO, TO_CHAR(SYSDATE, 'YYYYMMDD') AS FECHAEXT, ENC.NOTAOTORGANTE, CIRCRED.valida_cc.QUITASIGNOS(VCL.APELLIDOPATERNO) AS VAL_APELLIDOPATERNO, CIRCRED.valida_cc.QUITASIGNOS(VCL.APELLIDOMATERNO) AS VAL_APMATERNO, CIRCRED.valida_cc.QUITASIGNOS(VCL.APELLIDOADICIONAL) AS APELLIDOADICIONAL , CIRCRED.valida_cc.QUITASIGNOS(VCL.NOMBRES) AS NOMBRES, VCL.FECHANACIMIENTO, circred.valida_cc.valida_rfc(

Tags (comma-separated) Cancel