db2在存储过程中使用for循环报错-104 42601
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