利用存储过程创建表提示权限不足，但是单独创建就可以
create or replace procedure PRC_GZF_BZ_YWSLID(ywslid in verchar2) as
L_YWSLID verchar2(30);
tpg_gzfspbnum verchar2(30);
begin
L_YWSLID:=ywslid;
tpg_gzfspbnum:='tpg_gzfspb'||L_SLIDID;
execute immediate'
create table '||tpg_gzfspbnum||' as select * from
GZF_ZFBZ.tpg_gzfspb@gzf_zfbz where ywslid = '''||L_YWSLID||'''';
end PRC_GZF_BZ_YWSLID;
各位大佬，求教.
