title: Calling Oracle Stored proc with user define type array
body: <p>I need to call a stored procedure in oracle. One of the parameters is a user defined type like so:</p>
  
  <pre><code>CREATE OR REPLACE TYPE MY_PK AS OBJECT
  (
    SOURCE_ID INTEGER,
    ACCT_SYSTEM VARCHAR2(255)
  )
  /
  
  CREATE OR REPLACE TYPE MY_PK_ARR AS TABLE OF MY_PK
  /
  
  PROCEDURE get_data(pk_in IN my_pk_arr, my_coursor OUT t_cursor)
  IS 
   ...
  END
  </code></pre>
  
  <p>I am trying to call it like so:</p>
  
  <pre><code>var    pk          my_pk_arr 
  var    my_cursor   t_cursor
  execute  myschema.mypackage.get_data (pk ,  :my_cursor);
  </code></pre>
  
  <p>I can't figure out how to create the array. Is this possible or I need to create some sort of table to do it?</p>
  
  <p>Thanks</p>