title: Dynamic call Store Procedure (execute immediate ) Out parameters Problems
body: <p>I have problem Dynamic Call Store Procedure </p>
  
  <pre><code>    v_sql      := 'begin '|| p_procname ||  '(''test1'','' test2 '',:v_output2);  end;';
      execute immediate v_sql
      using  out v_output2 ;
      dbms_output.put_line(v_output2 || ' ' );
  </code></pre>
  
  <p>In here ı can call procedure with execute immediate .
  But my problem is dynamic bind variable . This values comes from log table then i parse for execute_immediate procedure </p>
  
  <pre><code>    v_sql      := 'begin '|| p_procname ||  '(''test1'','' test2'',:v_output2);  end;';
      v_sql1:= ||using||  'out v_output2 ' ;
  
      execute immediate v_sql
      v_sql1;
  </code></pre>
  
  <p>It doesnt work like that . How can i make dynamic variables bind , because  i call a lot of procedure and thats procedure has different in and out parameters. 
  I hope you can understand what problem i have .How can i pass this problems thx </p>