call oracle stored procedure - Exception: Bigger type length than Maximum

[Habib_E]

Hi everyone, I use Jaspersoft iReport Designer 5.5.0.

I've tried to call a stotred procedure from this wiki page : http://community.jaspersoft.com/wiki/how-execute-oracle-stored-procedure-jasper-report-ireport-editor-environment

I did all steps exactly as the wiki page said.

I've created a procedure :

PROCEDURE emplist_proc(emp_cursor OUT sys_refcursor) IS [/code]

BEGIN     [/code]

OPEN emp_cursor FOR[/code]

    SELECT first_name,last_name,email[/code]

     FROM employees     Where Rownum < 10; [/code]

END; [/code]

 

and then I execute the oracle stored procedure by writing this:  {call emplist_proc($P{ORACLE_REF_CURSOR})}.

also I set language to plsql.

but when I execute report by clicking Preview button the below exception raises:

 

Error filling print... Error executing SQL statement for : report2net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report2     at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:143)     at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1112)     at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:689)     at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)     at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87)     at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)     at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.sql.SQLException: Bigger type length than Maximum     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)     at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:885)     at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.java:2231)     at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.java:1048)     at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTIdcb.java:112)     at oracle.jdbc.driver.T4CTTIdcb.receiveFromRefCursor(T4CTTIdcb.java:104)     at oracle.jdbc.driver.T4CResultSetAccessor.unmarshalOneRow(T4CResultSetAccessor.java:165)     at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:788)     at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:705)     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:527)     at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:180)     at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:783)     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2979)     at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4103)     at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:128)     ... 12 more Print not filled. Try to use an EmptyDataSource...[/code]

I'm so confused where I'm wrong.

Regards,

Habib

 

[james.t]

Have you looked into this bug in the Oracle driver?

 

http://stackoverflow.com/questions/2788030/exception-while-calling-stored-procedure-bigger-type-length-than-maximum