oracle使用游标循环更新数据

DECLARE
CURSOR cur IS
SELECT *
FROM FCC_TemplateManagement
FOR UPDATE;
rec cur%ROWTYPE;
new_val int := 0;
BEGIN
OPEN cur;
LOOP
FETCH cur INTO rec;
EXIT WHEN cur%notfound;
new_val := new_val + 1;
UPDATE FCC_TemplateManagement
SET Id = new_val
WHERE CURRENT OF cur;
END LOOP;
CLOSE cur;
END;