一个很简单的插入，不懂是哪里错了？

[Im_root]

execute insert_tab;
begin insert_tab; end;
ORA-00984: column not allowed here
ORA-06512: at "SCOTT.INSERT_TAB", line 7
ORA-06512: at line 1


create or replace procedure insert_tab
is
v_insert_tab varchar2(1000);
begin
for i in 1..100 loop
v_insert_tab:='insert into test_tab(id,name) values (i,''aa'')';
execute immediate v_insert_tab; //这句话报错
commit;
end loop;
end insert_tab;

[碧水幽幽泉]

create or replace procedure insert_tab 
is 
v_insert_tab varchar2(1000);
begin
for i in 1..100 loop
    v_insert_tab :='insert into test_tab(id,name) values ( 1,"aa")';
    commit;
  end loop;
end insert_tab;

改成:

create or replace procedure insert_tab 
is 
begin
  for i in 1..100 loop
     v_insert_tab :='insert into test_tab(id,name) values (1,''aa'')';
    execute immediate v_insert_tab; 
    commit;
  end loop;
end insert_tab;

也是OK的。

[碧水幽幽泉]

推荐第一种写法。性能好些！

[江南小鱼]

oracle语法，字符串用单引号

[神临物语]

i是参数，不能直接写在动态sql里面，改成下面这样就好了 v_insert_tab := 'insert into pec.gt_temp(n1,v2) values ('|| i ||',''aa'')'

[碧水幽幽泉]

create or replace procedure insert_tab 
is 
v_insert_tab varchar2(1000);
begin
for i in 1..100 loop
    v_insert_tab :='insert into test_tab(id,name) values ( 1,"aa")';
    commit;
  end loop;
end insert_tab;

改成:

create or replace procedure insert_tab 
is 
begin
  for i in 1..100 loop
     insert into test_tab(id,name) values (i,'aa');
    commit;
  end loop;
end insert_tab;

即可