title: Display the output of EXECUTE IMMEDIATE statement
body: <p>I have a stored procedure to truncate the table whose name is passed as a parameter to the procedure.</p>
  
  <pre><code>create or replace procedure delete_data_from_table(table_id VARCHAR2)
  is
      cursor table_cur is
          SELECT table_name FROM all_tables WHERE table_name LIKE '%' || table_id || '%';
      tab_name VARCHAR2(25);
  BEGIN
      open  table_cur;
      LOOP
          FETCH table_cur into tab_name;
          exit when table_cur%notfound;
          EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || tab_name;
      END LOOP;
      close table_cur;
  END;
  </code></pre>
  
  <p>I want to display the output of the <code>execute immediate</code> statement using <code>DBMS_OUTPUT.PUT_LINE</code>. Is it possible to do so?</p>
  
  <p>Thanks in advance.</p>