title: Dynamically call PL/SQL procedure with output variables
body: <p>I'm trying to use dynamic sql to execute a procedure and retrieve the output parameters:</p>
  
  <pre><code>v_sql := 'BEGIN ' || p_procname || '(''' || p_input1 || ''', ''' || p_input2 || ''', v_output1); END;';
  DBMS_OUTPUT.PUT_LINE(v_sql);
  EXECUTE IMMEDIATE v_sql;
  </code></pre>
  
  <p>I have the <code>v_output1</code> variable declared, but I get this error message:</p>
  
  <pre><code>PLS-00201: identifier 'V_ISSUE' must be declared 
  </code></pre>
  
  <p>The procedure works if I replace the above code with the dbms_ouput from <code>v_sql</code>, so it's OK on the procedure side, the issue is somewhere in how I'm trying to call it dynamically.</p>
  
  <p>I don't know if what I'm trying to do will work this way.  Is there a way to retrieve the output parameters from this procedure call through dynamic SQL?</p>