title: Unable to create table using pl/sql
body: <pre><code>declare
  type yy is table of t12.name%type index by binary_integer;
  y yy;
  n number:=1;
  begin
  execute immediate 'create table rat1 ( name varchar2(10) )';
  commit;
  
  select name bulk collect into y from t12;
  for i in (select id,name from t12)
  loop
  dbms_output.put_line(y(n));
  n:=n+1;
  end loop;
  forall i in y.first..y.last
  insert into rat1 values(y(i));
  end;
  </code></pre>
  
  <p>Its giving <code>ora-00942</code>.
  I checked about it...at some website it was mentioning that you have to give following privilages...</p>
  
  <pre><code>grant select on sys.v_$paramenter to abc
  </code></pre>
  
  <p>I am unable to do that also..Can any body help me with this</p>