title: Executing a Stored procedure
body: <p>I'm trying to execute an oracle stored procedure that has an in-out parameter of table of record:</p>
  
  <pre><code>TYPE RECORD_TYP IS RECORD (
      CAT_CD                 VARCHAR2(4),
      MOD_ID       NUMBER(6)
  );
  </code></pre>
  
  <p>I found this example that talks about <code>List&lt;String&gt;</code> and <code>List&lt;Integer&gt;</code>:
  <a href="http://viralpatel.net/blogs/java-passing-array-to-oracle-stored-procedure/" rel="nofollow">http://viralpatel.net/blogs/java-passing-array-to-oracle-stored-procedure/</a>.</p>
  
  <p>But what about <code>List&lt;MyRecordDTO&gt;</code>?</p>
  
  <p>EDIT: I found an answer here where the poster used an oracle.sql.STRUCT type.
  <a href="http://betteratoracle.com/posts/32-passing-arrays-of-record-types-between-oracle-and-java" rel="nofollow">http://betteratoracle.com/posts/32-passing-arrays-of-record-types-between-oracle-and-java</a></p>
  
  <p>Using this example, I found the exception <code>java.sql.SQLException: Internal Error: Inconsistent catalog view</code>. Googling this exception, I called the DBA to grant me access to "<code>RECORD_TYP</code>"</p>