应该这样:
create or replace procedure p_test(tbName in varchar2) is
v_sql varchar2(100);
begin
v_sql:=insert into gg(gg) values('123323434')';
execute immediate v_sql;
commit;
end ;
create or replace procedure p_test(tbName in varchar2) is
v_sql varchar2(100);
begin
v_sql:=insert into gg(gg) values('123323434')';
execute immediate v_sql;
commit;
end ;
我在sqlplus里通过如下语句调用成功
begin
insertgg;
end;