title: How to execute a stored procedure with parameters from a variable?
body: <p>I have a variable which contains a name of a stored procedure. I want to execute this procedure with dynamic sql, so I did this : </p>
  
  <p><strong>var_procedure</strong> is the variable which contain the name of my stored procedure. <strong>firstparameter</strong> and <strong>secondone</strong> are my varchar parameters for the stored procedure.</p>
  
  <pre><code>execute immediate var_procedure||'('''||firstparameter||''','''||secondone||''')';
  </code></pre>
  
  <p>It's not working and I have this basic error printed : </p>
  
  <pre><code>ORA-00900: invalid SQL statement
  </code></pre>
  
  <p>Do you have a solution ?</p>