title: How to call an Oracle procedure from Java callablestatement with typed params?
body: <p>I've to call from a Java application with JDBC Oracle driver a stored procedure in a Oracle DB in wich some parameters are simple types (VARCHAR2, NUMBER, ...) and others are objects or event table of object.</p>
  
  <pre><code>create or replace 
  type t_TYPE as object (In_PARAM VARCHAR2(255)   );
  
  create or replace 
  type t_TYPE_array is table of t_TYPE ;
  
  PROCEDURE SOME_PROC (in_myParam IN t_TYPE_array, out_retVal OUT NUMBER) AS ...
  </code></pre>
  
  <p>I'm on Java 1.6 and ojdbc6, my way is for java.sql.CallableStatement, but I'm open to other solutions (on top of the JDBC driver).</p>
  
  <p>P.S. It's an Enterprise app running in Jboss 5 (connection from a datasource).</p>
  
  <p>Thanks</p>