write PL/SQL code in jasper

[Habib_E]

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

[hozawa]

Instead of writing PL/SQL in Jaspersoft, create them in Oracle and call them as stored procedure. There's a wiki page below:

http://community.jaspersoft.com/wiki/how-execute-oracle-stored-procedure-jasper-report-ireport-editor-environment

[Habib_E]

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

[rick.stone]

I have the same question - is it possible to include anonymous pl/sql blocks in jrxml files? In my situation I have no permission to create a stored procedure in the reporting database, and pl/sql solves some issues. Thanks -- Rick

[Habib_E]

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

Regaeds,

Habib

 

[MariaF]

@Habib_E I just asked a question today in this forum about calling a plsql function with multiple parameters from Jasper reports. Do you have any tips for that? For proof of concept, I am using select mysch.my_function ('string 1', 'string2') from DUAL. This works. But when I try to do 

select mysch.my_function ($P{mypar1},  'string2') from dual instead, I am getting jasper errors column not found and invalid design. Parameter mypar1 is just a String parameter at prompt. It doesn't like the parameter passing in the function.