title: Oracle stored procedure hanging when called via jdbc
body: <p>I have a web application which executes oracle stored procedures and shows the results on a browser.
  The technology stack is as follows: Browser &lt;-> spring mvc &lt;-> [(tomcat)jboss] &lt;-jdbc-> oracle.
  The stored procedures have an out cursor for the results and the java code uses that cursor to retrieve the resultset.</p>
  
  <p>Everything was running fine until a new stored procedure was added, which although terminates fast enough in SQL Developer, it freezes when it gets called from the application. The java debugging showed that the code freezes at the OracleCallableStatement.execute. Initially I thought there was something wrong with the procedure but it does run successfully on sql developer, so I am now pointing more towards a jdbc problem...</p>
  
  <p>I guess this has to do with some sort of deadlock while reading the out cursor, or could it be a bug in the jdbc driver (version I am using: ojdbc6 - 11.1.0.7.0)?
  Any ideas?  </p>
  
  <p>Thanks</p>