存储过程如下:
create or replace procedure proc_tmp is
dynamic_sql varchar2(100);
begin
dynamic_sql := 'CREATE TABLE t_tmp(a VARCHAR2(24),b VARCHAR2(24))';
EXECUTE IMMEDIATE dynamic_sql;
end;
提示没有权限,是什么原因呢?
create or replace procedure proc_tmp is
dynamic_sql varchar2(100);
begin
dynamic_sql := 'CREATE TABLE t_tmp(a VARCHAR2(24),b VARCHAR2(24))';
EXECUTE IMMEDIATE dynamic_sql;
end;
提示没有权限,是什么原因呢?