title: Launch Oracle stored-procedure in Java code
body: <p>I wrote a stored-procedure in Oracle and now, I want to launch it in Java code.
  I will describe a problem. I have a object type:</p>
  
  <pre><code>TYPE PERSON_TYPE AS OBJECT (ID NUMBER(38), NAME VARCHAR2(20));
  </code></pre>
  
  <p>And table type:</p>
  
  <pre><code>TYPE PERSON_TYPE_TABLE AS TABLE OF PERSON_TYPE;
  </code></pre>
  
  <p>My procedure looks like this:</p>
  
  <pre><code>PROCEDURE EVALUATE_PERSON_PROC(P_PERSON_ID IN NUMBER, return_data OUT NOCOPY PERSON_TYPE_TABLE) 
  AS
  --Some code
  BEGIN
  --Some code
  END;
  </code></pre>
  
  <p>How to launch this procedure in Java code? Which classes are the best to do it?</p>