title: JDBC result set from an Oracle PL/SQL stored procedure
body: <p>What does oracleClose() and oracleCloseQuery() do in sqlj.runtime.ExecutionContext.OracleContext. </p>
  
  <p>Since we upgraded jdbc driver jar to <code>ojdbc5.jar</code> with the <code>oracleClose()</code> in the finally block we get the below exception when using <code>resultset.next()</code> and not with <code>oracleCloseQuery()</code>. Is it safe to use <code>oracleCloseQuery()</code>. The database is Oracle 11g and WAS 6.1.X.X. Appreciate your response.
  Here is the error message : </p>
  
  <blockquote>
    <p>java.sql.SQLException: Closed Statement: next
    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:269)
    at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:205)
    at com.westgroup.pubsvc.rms.models.ResultSetSRC.getNextResult(ResultSetSRC.java:112)</p>
  </blockquote>