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!

Download from JasperServer to Apex

OraclePSPFeb 27 2015 — edited Apr 29 2015

Hi all,

my need is to call a jasperrepor in an apex application and download/preview the pdf directly.

I found several times procedures that use utl_http ,dbms_lob ,owa_util and wpg_docload like :

- http://damien.antipa.at/2011/11/04/apex-and-jasperserver-tunnel-plugin/

- Another Oracle Blog: JasperReports in Apex

It seems to work fine but at line

owa_util.mime_header('application/pdf');

this error is raised

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "SYS.OWA_UTIL", line 356

ORA-06512: at "SYS.HTP", line 1368

ORA-06512: at "SYS.HTP", line 1443

ORA-06512: at "SYS.HTP", line 1735

ORA-06512: at line 76

I'am working with Application Express 4.1.1.00.23 and Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

Thanks to all for any help or suggestion.

PS: my second need will be add a line like this

htp.p('Content-Disposition: inline;');

in order to preview the pdf into the browser without the open/save dialog, i'am on the right path?.

This post has been answered by Kiran Pawar on Mar 4 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2015

Added on Feb 27 2015

#apex-discussions

5 comments

1,996 views