Cursor is closed error

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

prashant1406's picture
Joined: Feb 5 2015 - 4:49am
Last seen: 8 years 7 months ago

0 Answers:

No answers yet
Feedback
randomness