create or replace procedure c_table(tablename varchar2)
as
begin
execute immediate 'create table ' ||tablename|| ' (name varchar2(10))';
end;
set serveroutput on;
execute c_table('tb6');
declare
sqlstring varchar2(100);
begin
sqlstring := 'commit';
execute immediate 'insert into tb6 values("xiao")';
execute immediate sqlstring;
end;
#################错误:
declare
*
第 1 行出现错误:
ORA-00984: 列在此处不允许
ORA-06512: 在 line 5
求大神讲解!
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28459830/viewspace-758006/
,如需转载,请注明出处,否则将追究法律责任。