hi friends
i have a procedure which out an sys_refcursor in pl/sql block. after i take cursor i want to fetch and put data in record but it gives ora 06504 error. how can we solve it?
DECLARE
RC_CURSOR SYS_REFCURSOR;
TYPE IZIN_HAK
IS RECORD (
NTIP_IZIN_TUR_ID IKY_TNM_PER_TUR_IZIN.NTIP_IZIN_TUR_ID%TYPE,
NVDEGER GNL_SBT_TIP_DEGER.NVDEGER %TYPE,
NKAC_GUN NUMBER,
KULLANILAN_IZIN NUMBER,
BTEKRAR IKY_TNM_PER_TUR_IZIN .BTEKRAR %TYPE ,
BDEVIR IKY_TNM_PER_TUR_IZIN.BDEVIR %TYPE
);
KAYIT IZIN_HAK;
BEGIN
PCK_IKY_IZIN.P_PER_IZIN_GETIR(NULL, RC_CURSOR,2, NULL, 748);
LOOP
FETCH RC_CURSOR INTO KAYIT;
EXIT WHEN RC_CURSOR%NOTFOUND;
END LOOP;
END;