title: Oracle : Execute Stored Procedure with table type input variable
body: <p>When I tried to debug an existing app, I found 1 method which is execute a stored procedure showing an error. I want to execute the Stored Procedure on my Oracle SQLDeveloper, given procedure :</p>
  
  <pre><code>type numTableType is table of NUMBER index by binary_integer;
  
  PROCEDURE up_correction_status(p_exp_check_id IN numTableType, p_status_id NUMBER, p_user_id NUMBER, p_return OUT NUMBER);
  </code></pre>
  
  <p>but, how to declare value of <code>numTableType</code> ?</p>
  
  <p>I tried to :</p>
  
  <pre><code>var p_return NUMBER;
  execute "PKG_PDM_DASHBOARD".up_approved_corr_status(1, 2, 11, :p_return);
  print p_return;
  </code></pre>
  
  <p>Found this error : </p>
  
  <blockquote>
    <p>Error starting at line 2 in command:
    execute "PKG_PDM_DASHBOARD".up_approved_corr_status(1, 2, 11, :p_return)
    Error report:
    ORA-06550: line 1, column 8:
    PLS-00306: wrong number or types of arguments in call to 'UP_APPROVED_CORR_STATUS'
    ORA-06550: line 1, column 8:
    PL/SQL: Statement ignored</p>
  </blockquote>
  
  <p>just want to execute it and get return value</p>