CREATE OR REPLACE PROCEDURE Z_PROCEDURE_TEST AS
i NUMBER;
CURSOR CUR IS SELECT * FROM T_ZTEST WHERE 1=1;
BEGIN
FOR CUR_T IN CUR LOOP
IF(CUR_T.NAME='美人鱼2') THEN
UPDATE T_ZTEST SET NAME='美人鱼3';
i:=i+1;
IF(i=3)THEN
COMMIT;
DBMS_OUTPUT.put_line(i);
i:=0;
END IF;
END IF;
END LOOP;
COMMIT;
END Z_PROCEDURE_TEST;
为什么i的值没有输出来呢