can any one help me know how to use reference cursor query in reports 9i

for that i was trying to create a pakage but i am facing some error can any one help me

the code is given below.The database tabel name ia MRVS
PACKAGE consign_dt_proc AS
type consign_dt is RECORD
(MRV_NO MRVS.MRV_NO%type ,_
ENTRY_DT MRVS.ENTRY_DT%type ,_
CONSIGN_NO MRVS.CONSIGN_NO%type ,
CONSIGN_DT MRVS.CONSIGN_DT%TYPE ,
INV_DT MRVS.INV_DT%TYPE ,
INV_NO MRVS.INV_NO%TYPE ,
CHALL_DT MRVS.CHALL_DT%TYPE ,
CHALL_NO MRVS.CHALL_NO%TYPE ,
PO_NO MRVS.PO_NO%TYPE ,
AWB_NO MRVS.AWB_NO%TYPE ,
MRV_RMKS MRVS.MRV_RMKS%TYPE ,
ED MRVS.ED%TYPE ,
ED_PERCNT MRVS.ED_PERCNT%TYPE ,
bkd_frm consigns.bkd_frm ,
bkd_to consigns.bkd_to ,
vend_nm vend_bas.vend_nm ,
FIN_VAL number
);

type CONSIGTN_DT_REF_CUR is REF CURSOR return consign_dt;
function CONSIGN_DT_FUNC(P_CONSIGN_DT DATE) return CONSIGTN_DT_REF_CUR;

END consign_dt_proc;