title: Why the select statement is not showing me table while executed in oracle?
body: <p>I am new to oracle.I already have a table <code>tempash</code>.
  So,I created a procedure to see the data of this table.
  So,I created procedure as:</p>
  
  <pre><code>create or replace procedure offc.temp_sel(data1 varchar2) is
     var1 varchar2(4000);
  BEGIN
   var1:='select * from  offc.temp'||data1;
     EXECUTE IMMEDIATE var1;
   end;
  </code></pre>
  
  <p>So,I executed the statement but,it is not showing me anything.</p>
  
  <pre><code> exec offc.temp_sel('ash');
  </code></pre>
  
  <p>There is no any compilation error in my procedure.But why the select statement is not showing me data of that procedure?</p>