Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

fetch sys_refcursor into record problem

JAVAMAN2Dec 4 2009 — edited Dec 4 2009
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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2010
Added on Dec 4 2009
9 comments
3,051 views