Oracle中的存储过程可以这样写吗？

[moshangchen]

我有个存储过程：
PROCEDURE PROC_PJ_BILLININIT_GETLIST(PINSTORAGEID IN PJINSTORAGE.INSTORAGEID%TYPE,
RECORDSET OUT REF_CURSOR) IS


BEGIN
OPEN RECORDSET FOR
SELECT INSTORAGEID,
INSTORAGEITEMSID,
SUMMARY,
PJINSTORAGEITEMS.BILLDICTID,
SIGN,
STARTNO,
ENDNO,
AMOUNT,
BILLDICTCODE,
BILLDICTNAME,
BILLTYPEID,
SPEC,
NORULE,
RATIONFLAG,
PARVALUE,
AMOUNT * PARVALUE AS SUMVALUE
FROM PJINSTORAGEITEMS INNER JOIN PJBILLDICT ON PJINSTORAGEITEMS.BILLDICTID = PJBILLDICT.BILLDICTID
WHERE INSTORAGEID = PINSTORAGEID;

FOR REC IN RECORDSET LOOP
IF REC.SUMVALUE = 0 THEN
REC.SUMVALUE :=100;
END IF;
END LOOP;
CLOSE RECORDSET;
END PROC_PJ_BILLININIT_GETLIST;
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
FOR REC IN RECORDSET LOOP
IF REC.SUMVALUE = 0 THEN
REC.SUMVALUE :=100;
END IF;
END LOOP;
这段语句我想用游标，每取出一会后判断这行游标中的SUMVALUE等于0，我让它等于100。这样取出的记录集是不是我已经设置的？

请问怎么写？