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

[skyclub]

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;
/

[skyclub]

UP

[skyclub]

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

[beckhambobo]

没有错，把全代码和错误信息贴出来吧

[skyclub]

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

[MicroMouse]

编译时的错误信息是什么？

[skyclub]

翻译:
过程建立,但是编译有错.

[skyclub]

郁闷中...............

[jlandzpa]

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;

[jlandzpa]

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;

[skyclub]

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