How to use Stored procedure for iReport 5.6.0.?

Hi,

i have allready follow that instructions :http://community.jaspersoft.com/wiki/ireport-calling-stored-procedures. when i create manually the fields all seems ok for first time. when i load/reopen  ireport report does not run. when i restart ireport and try to preview i have this error:

net.sf.jasperreports.engine.design.JRValidationException: Report design not valid :
     1. Query parameter not found : ORACLE_REF_CURSOR
    at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:271)
    at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:153)
    at net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:354)
    at net.sf.jasperreports.engine.JasperCompileManager.compileToFile(JasperCompileManager.java:270)
    at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:563)
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:528)
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

anyone help?

regards,

Adven

dimdimitrako's picture
Joined: Apr 16 2015 - 6:43am
Last seen: 5 years 9 months ago

0 Answers:

No answers yet
Feedback
randomness