Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Regarding Jaspersoft - iReport / Parameters and BLOB

828151Apr 15 2011 — edited Apr 19 2011
Hello all,

I installed iReport and was making some tests, already create one Report with some parameters that I'm hardcoding when I run the report, I'd like to know how pass this values through APEX, until now I have this:
begin
  xlib_jasperreports.show_report ( p_rep_name => 'TESTEREP',
                                   p_rep_format => 'pdf',
                                   p_data_source => 'Kunden',
                                   -- Is this the name of my DB Connection?? Because I don't have a data_source on the iReport
                                   p_out_filename => 'Teste1.pdf',
                                   p_rep_locale => '', -- This value is where the report is saved ??
                                   p_rep_encoding => '', -- This one is like UTF-8?
                                   p_additional_params => :p5_additional_params);                      
                                   -- What is the sintax to pass the parameters?
                                   -- It's name must be the same of the parameters that i'm receiving at the iReport? Or just the order matters?

  -- stop rendering of the current APEX page
  apex_application.g_unrecoverable_error := true;
end;	
What is necessary to load an image of a BLOB column at the iReport, I tried to open "directly" but it returns me:

oracle.sql.BLOB@1b87a10


Best Regards,
Alan Martini.
This post has been answered by PCHIU on Apr 15 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2011
Added on Apr 15 2011
5 comments
1,482 views