[write PL/SQL code in jasper]

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

Regaeds,

Habib

 

[write PL/SQL code in jasper]

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

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

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

 

[write PL/SQL code in jasper]

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