定义 max 为变量名造成的.
把 max 改为 imax 就可以了.SQL> create or replace procedure insert_to_testa(imax in number)
2 is
3 begin
4 declare
5 i number;
6 begin
7 for i in 1..imax loop
8 insert into testa(id,name)values(i,'name'||i);
9 end loop;
10 end;
11 end;
12 /Procedure created
把 max 改为 imax 就可以了.SQL> create or replace procedure insert_to_testa(imax in number)
2 is
3 begin
4 declare
5 i number;
6 begin
7 for i in 1..imax loop
8 insert into testa(id,name)values(i,'name'||i);
9 end loop;
10 end;
11 end;
12 /Procedure created
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货