title: Passing varchar2 parameter to plsql procedure from the Select statement
body: <p>Executing the following statement in Oracle Toad</p>
  
  <pre><code>exec plsql_procedure(select 'somestring' from dual);
  </code></pre>
  
  <p>trhows the following exception: </p>
  
  <p>ORA-06550: line 1, column 33:
  PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:</p>
  
  <p>( ) - + case mod new not null 
      </p>
  
  <p>Procedure takes one VARCHAR2 parameter. How it can be fixed? </p>