高手们,请看看下面一段代码,为什么编译不了?

Question

CREATE OR REPLACE PROCEDURE DDD(
V_INSERT_NUMBER IN NUMBER) IS
V_INSERT_NUMBER_TEMP NUMBER;
V_ID NUMBER;
BEGIN
V_INSERT_NUMBER_TEMP : = 1;
LOOP
INSERT INTO ZHANG1(USERID,NAME,AGE,MONEY) VALUES(ID_SEQUENCE.NEXTVAL,'ROBOT',24,8888)
V_INSERT_NUMBER_TEMP : = V_INSERT_NUMBER_TEMP + 1;
IF V_INSERT_NUMBER_TEMP > V_INSERT_NUMBER THEN
EXIT;
END IF;
END LOOP;
END;
/

Answer 1

注:其中的INSERT INTO 语句没有问题

Answer 2

警告: プロシージャが作成されましたが、コンパイル・エラーがあります

Answer 3

CREATE OR REPLACE PROCEDURE DDD(
V_INSERT_NUMBER IN NUMBER) IS
V_INSERT_NUMBER_TEMP NUMBER;
V_ID NUMBER;
BEGIN
V_INSERT_NUMBER_TEMP := 1;
LOOP
INSERT INTO ZHANG1(USERID,NAME,AGE,MONEY) 
VALUES(ID_SEQUENCE.NEXTVAL,'ROBOT',24,8888);

V_INSERT_NUMBER_TEMP := V_INSERT_NUMBER_TEMP + 1;

IF V_INSERT_NUMBER_TEMP > V_INSERT_NUMBER THEN
EXIT;
END IF;
END LOOP;
END;

Answer 4

CREATE OR REPLACE PROCEDURE DDD(
V_INSERT_NUMBER IN NUMBER) IS
V_INSERT_NUMBER_TEMP NUMBER;
V_ID NUMBER;
V_tmp NUMBER;BEGIN
V_INSERT_NUMBER_TEMP := 1;
LOOP
     select ID_SEQUENCE.NEXTVAL into V_tmp from dual;
INSERT INTO ZHANG1(USERID,NAME,AGE,MONEY) 
VALUES(V_tmp,'ROBOT',24,8888);

V_INSERT_NUMBER_TEMP := V_INSERT_NUMBER_TEMP + 1;

IF V_INSERT_NUMBER_TEMP > V_INSERT_NUMBER THEN
EXIT;
END IF;
END LOOP;
END;

Answer 5

tx.... 多了空格
谢谢jlandzpa(jlandzpa)
结帐.