db2在存储过程中使用for循环报错-104 42601

[liyill]

CREATE PROCEDURE TESTFOR()
LANGUAGE SQL
BEGIN
DECLARE V_TEMP1 VARCHAR(2);
DECLARE V_TEMP2 VARCHAR(70);
FOR V1 AS CURSOR1 CURSOR FOR
SELECT STUDENT_ID AS TEMP1,STUDENT_NAME AS TEMP2 FROM STUDENT
DO
DELETE FROM STUDENT WHERE STUDENT_ID = V1.TEMP1;
SET V_TEMP1 = V1.TEMP1;
SET V_TEMP2 = V1.TEMP2;
END FOR;
COMMIT;
END;




报错[-104] 在 "END" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括："JOIN <joined_table>"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.64.106

[-104] 在 "1.TEMP2" 后面找到异常标记 "END-OF-STATEMENT"。预期标记可能包括："
END FOR"。. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.64.106

[老李2018]

建议你参考下：https://blog.csdn.net/wangjichen_1/article/details/60959144