Habib_E

I don't think so, I use stored procedure for this issue. Regaeds, Habib

Thanks, you mean that it isn't possible to write pl/sql codes in jasper. Calling stored procedure is a way but I thought we could do it in jasper itself. We have many conditional statements, how we can write them in jasper? Regards, Habib

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

Hi everyone, I'm new to jasper world. I use Jaspersoft iReport Designer 5.5.0 and I need to call my reports in oracle ADF. I'm wondering if we can write pl/sql code in jasper and what is the best way for doing such works? soemthings like belows : begin if $P{param1} = 1 then select field_1 from table_1; else select field_2 from table_2; end if;...........end; [/code]Regrads, Habib