高手们,请看看下面一段代码,为什么编译不了?
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;
/
问题点数：20、回复次数：10Top
1 楼skyclub（临江仙人）回复于 2002-12-06 14:22:59 得分 0
UPTop
2 楼skyclub（临江仙人）回复于 2002-12-06 14:25:16 得分 0
注:其中的INSERT INTO 语句没有问题
Top
3 楼beckhambobo（beckham）回复于 2002-12-06 14:27:37 得分 0
没有错，把全代码和错误信息贴出来吧Top
4 楼skyclub（临江仙人）回复于 2002-12-06 14:29:25 得分 0
警告: プロシージャが作成されましたが、コンパイル・エラーがありますTop
5 楼MicroMouse（独步江湖）回复于 2002-12-06 14:29:31 得分 0
编译时的错误信息是什么？Top
6 楼skyclub（临江仙人）回复于 2002-12-06 14:31:10 得分 0
翻译:
过程建立,但是编译有错.Top
7 楼skyclub（临江仙人）回复于 2002-12-06 14:40:55 得分 0
郁闷中...............Top
8 楼jlandzpa（jlandzpa）回复于 2002-12-06 14:45:53 得分 20
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;Top
9 楼jlandzpa（jlandzpa）回复于 2002-12-06 14:49:01 得分 0
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;Top
10 楼skyclub（临江仙人）回复于 2002-12-06 14:56:11 得分 0
tx.... 多了空格
谢谢jlandzpa(jlandzpa)
结帐.
Top
