Pass cursor iteration as parameter to PL/SQL procedure or function

[Oscar Calderon]

Hi to all, i have the next situation:

I have a package with 2 procedures, procA and procB. Inside procA i call several times to procB. Inside procA i iterate over a cursor defined in the package, not in the procedure. The cursor is a query from various tables. I need to pass to procB the entire "row" of my cursor when i'm iterating because cursor query columns are a lot and i don't want to declare all those colums as parameters in procB. I've tried using REF CURSOR and RECORD but probably i do something wrong because it doesn't work.

Here's the code of my package:

create or replace package body TES_INT_PAGOS_AP as CURSOR cPagos(p_fi IN DATE, p_ff IN DATE) IS SELECT a.campo1 as c1, b.campo1 as c2, c.campo1 as c3 from tbl1 a, tbl2 b, tbl3 c; TYPE rVarPago IS REF CURSOR RETURN cPagos%ROWTYPE; PROCEDURE procB(pIdPago IN NUMBER, pIdCtb IN NUMBER, vPago IN rVarPago, ACCION IN VARCHAR2) AS VARDUMMY NUMBER(10); BEGIN ... SELECT CAMPITO INTO VARDUMMY FROM TABLA4 WHERE CAMPO1 = rVarPago.c2; END; PROCEDURE procA(pFechaIni in DATE, pFechaFin in DATE, pCodcia in VARCHAR2, pResultado OUT VARCHAR2) AS BEGIN FOR rPagos IN cPagos(pFechaIni, pFechaFin) LOOP procB(1, 3, rPagos, 'UPD'); END LOOP; END; END TES_INT_PAGOS_AP;

What's wrong in my ref cursor?

Regards.

[Gene Hilpert]

On line 14 I think it should be = vPago.c2 not =rVarPago.c2 because rVarPago is a type