I'm using Oracle 11g, trying to call a stored procedure which returns a ref cursor. The issue is that we need to reuse the connection because the stored procedure uses a global temp table.
I notice that the cursor returned from the stored proc is not closed despite doing resultset.close and statement.close. How do I close the cursor without closing the connection? I'm using Java 7, ojdbc7.jar
I've tried connection.commit(), but that does not release resources.