for循环

FOR DATAROW IN (SELECT HANDLER                        FROM KXSTEPIII.SUPPLIER_VERIFY_CUR_HANDIER                       WHERE BILL_ID = PS_BILL_ID                         AND BILLSTATUS = '30'                       GROUP BY HANDLER) LOOP        V_NSV_MINISTER := DATAROW.HANDLER;        PRO_SENDMAIL('501', V_BILL_NO, '认证结论审批', V_NSV_MINISTER);      END LOOP;