I am calling oracle stored procedure and getting cursor closed error.
Stored Procedure runs fine in pl/sql developer and i am not closing the cursor in the procedure code.
The error comes only if i use table in the jasper report.
Caused by: 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.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:110)
... 6 more
0 Answers:
No answers yet