AnsweredAssumed Answered

Oracle REF CURSOR used in Jaspersoft Data Set

Question asked by mphelan on Jan 3, 2017
Latest reply on Jan 19, 2017 by mphelan

I have an existing Business Objects report which has an Oracle RDBMS data source. That data source is an Oracle STORED PROCEDURE, and returns a REF CURSOR.


I have seen little information concerning the integration of Jaspersoft with Oracle REF CURSOR data sets and queries. According to the JDBC description, REF CURSOR is an accepted data type for JDBC, which drives the data connections to Jaspersoft.


My efforts to use the REF CURSOR as a data source in the Jaspersoft Dataset and Query Dialog have resulted in ORA errors including:

net.sf.jasperreports.engine.JRException: Unable to get next record from result set.

Cannot perform fetch on PLSQL statement: next

net.sf.jasperreports.engine.JRException: Error executing SQL statement for: data.


Has anyone successfully connected to an Oracle STORED PROCEDURE returning a REF CURSOR within the Jaspersoft Dataset and Query Dialog?


I have tried using both the standard Oracle format, as well as the exec format described on the Jaspersoft Community Forum. Both return errors.