title: PLSQL: No output displayed when using dynamic query inside Stored Procedure
body: <p>I have been asked to create an SP which creates temporary table and insert some records.</p>
  
  <p>I am preparing some sample code for the same as mentioned below but the output is not displayed.</p>
  
  <pre><code>create or replace procedure Test
  is 
     stmt varchar2(1000);
     stmt2 varchar2(1000);
  begin
      stmt := 'create global temporary table temp_1(id number(10))';
      execute immediate stmt;
      insert into temp_1(id) values (10);
      execute immediate 'Select * from temp_1';
      execute immediate 'Drop table temp_1';
      commit;
  end;
  </code></pre>
  
  <p>When i am executing the SP by (Exec Test) desired O/P is not displayed.</p>
  
  <p>I am expecting O/P of "Select * from temp_1" to be displayed. But it is not happening. Please suggest where i am doing wrong.</p>