title: Why we can't execute stored procedure in select statement in oracle? is there any strong reason?
body: <pre><code>create or replace procedure pr
  is
      v_date date; 
  begin
      select sysdate into v_date from dual;
      DBMS_output.put_line(v_date);
  end pr;
  </code></pre>