posted 17 years ago
I am returning a ref cursor from my oracle procedure and trying to get the data in my DAO class. But I am getting the following error:
[2/1/07 18:38:41:766 IST] 0000003d SystemErr R java.sql.SQLException: Cursor is closed.
at oracle.jdbc.driver.T4CResultSetAccessor.getCursor(T4CResultSetAccessor.java:323)
at oracle.jdbc.driver.ResultSetAccessor.getObject(ResultSetAccessor.java:85)
at oracle.jdbc.driver.OracleCallableStatement.getObject(OracleCallableStatement.java:1401)
at com.ibm.ws.rsadapter.jdbc.WSJdbcCallableStatement.getObject(WSJdbcCallableStatement.java:443)
at com.harcourt.elearning.services.reporting.persistence.dao.classsummaryreport.ClassSummaryReportDAO.generateReport
Can any one help.
Thanks in advance.
Kaustubh