需添加“authid current_user”
如下:create or replace procedure newtable authid current_user is
tablename varchar2(100);
str varchar2(2000);
begin
tablename:=to_char(sysdate,'yyyymmdd');
str:='create table wcm'|| tablename ||' as select * from wcm1';
execute immediate str;
end ;
如下:create or replace procedure newtable authid current_user is
tablename varchar2(100);
str varchar2(2000);
begin
tablename:=to_char(sysdate,'yyyymmdd');
str:='create table wcm'|| tablename ||' as select * from wcm1';
execute immediate str;
end ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货