title: Oracle TABLE TYPE
body: <p>I have a scenario where I was using global objects, but I have been informed that some database changes means I can no longer do that. So I am passing an anonymous procedure through a Java prepared statement.</p>
  
  <p>I have passed in the parameter data as an xml which I have converted to a local type.</p>
  
  <pre><code>DECLARE
      xmlData XMLTYPE := ?
      TYPE o_myData IS RECORD (my_num NUMBER);
      TYPE t_myData IS TABLE OF o_myData INDEX BY BINARY_INTEGER;
      myData t_myData;
  BEGIN
      --xmlData conversion
  
      SELECT * FROM TABLE(t_myData) --does not work because the type is local
  </code></pre>
  
  <p>Are there any other options?</p>