title: Call Oracle stored procedure from Java App using hibernate and c3p0 connection pool
body: <p>I'm not able to find a way to do something that seems to me as a common task. </p>
  
  <p>I have </p>
  
  <pre><code>CREATE TYPE MyType AS OBJECT (field1 int, field2 int);
  CREATE PROCEDURE SP_TEST (obj IN MyType) AS ....    
  </code></pre>
  
  <p>How can I call this procedure from Java application ? I'm using hibernate and c3p0 connection pool that hides native jdbc connection, so I cannot cast its proxy connection to OracleConnection. I found that c3p0 has rawConnectionOperation, but I don't understand how to accomplish my task using it.   </p>
  
  <p>Any help is greatly appreciated</p>