存储过程中调用EXECUTE IMMEDIATE的“权限不足”问题

create or replace procedure create_table_test is
tmpstr varchar2(500);
v_cursor number;
j number;
begin
  for i in 10..120 loop
  begin
  tmpstr:= ‘create table DPC_TEST‘|| i ||‘ as select * from DPC_TEST WHERE 1=2‘;
  dbms_output.put_line(tmpstr);
  --v_cursor := dbms_sql.open_cursor;
  --dbms_sql.parse(v_cursor,tmpstr,dbms_sql.native);
  --j:=dbms_sql.execute(v_cursor);
  execute immediate tmpstr;
  exception
  when others then
  dbms_output.put_line(‘error create table!‘);
      DBMS_OUTPUT.put_line(‘sqlcode : ‘ ||sqlcode); 
      DBMS_OUTPUT.put_line(‘sqlerrm : ‘ ||sqlerrm); 
  end;
  end loop;
end create_table_test;