title: How to see stored procedure output on command line via sqlplus
body: <pre><code>CREATE OR REPLACE PROCEDURE TEST_PROC
  IS
    str varchar(100);
    rec_count INTEGER;
  
  BEGIN
      str := 'select count(*) from emp_record';
      EXECUTE IMMEDIATE str into rec_count;
      dbms_output.put_line(rec_count);
  END;
  </code></pre>
  
  <p>I can see output of this procedure in Toad(for oracle), but when i execute this in command line via sqlplus i see following output</p>
  
  <pre><code>SQL&gt; exec test_proc;
  
  PL/SQL procedure successfully completed.
  </code></pre>
  
  <p>so question is how can i see count output on command line.</p>