Re: PL/SQL question

Clint,

> BEGIN
> OPEN c_MILEAGE_CAL;
> LOOP
> EXIT WHEN c_MILEAGE_CAL%NOTFOUND;
> FETCH c_MILEAGE_CAL INTO
> V_EMPLOID, V_NUM_MILES, V_CENTSPERMILE, V_DATE, V_DESCR;
> V_REFUND := V_NUM_MILES * V_CENTSPERMILE;
> INSERT INTO EXPENSE_LOG
> VALUES(EXPLOG_COUNT_SEQ.NEXTVAL,V_EMPLOID,11004,V_REFUND,V_DATE,
V_DESCR,
> V_NUM_MILES );
> END LOOP;
> CLOSE c_MILEAGE_CAL;
> COMMIT;
> END;
Try putting the FETCH before the EXIT WHEN. The way you have it the FETCH fails, a row is inserted and then you exit the loop.

Andy Received on Fri Apr 04 2003 - 06:53:18 CST