CREATE OR REPLACE PROCEDURE V8_UPD_ZCNV_UPDATE IS

CURSOR FILLZCNV IS

SELECT MMOD_ID FROM MMOD ORDER BY MMOD_ID;

FILL FILLZCNV%ROWTYPE;

BEGIN

FOR FILL IN FILLZCNV LOOP

INSERT INTO ZCNV VALUES (SEQ_ZCNV.NEXTVAL,0, FILL.MMOD_ID, ' ', ' ');

END LOOP;

END V8_UPD_ZCNV_UPDATE;
/
