sql中的字符报错 - 大家帮忙看看

[shenghuiping2001]

我写了个procedure:

begin
loop
for i in 1 .. 10000
insert into emp values (i,'zhangshan');
end loop;
commit;
end;
/

报错：

ERROR at line 3:
ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe

大家有没有碰到这种问题啊？

[jamig]

你没有在for i in 1 .. 10000
后面加loop

[Rotel-刘志东]

是否执行此语句权限的。

[badiku]

[Quote=引用 1 楼 jamig 的回复:]

你没有在for i in 1 .. 10000
后面加loop
[/Quote]

哈哈，他写了loop的，只是位置写错了。