APEX

Dears,

I've received the error in the below snapshot while attempt to invoke a Jasper Report from a button on page created on Oracle APEX 5.1:

The button use a Page Process of type "PL/SQL Code" and execution point "Processing" and the Source "PL/SQL Code" used is:

| PL/SQL Code |
|

BEGIN

xlib_jasperreports.set_report_url(:G_REPORT_URL);

xlib_jasperreports.show_report (

                                p\_rep\_name            => 'REPORTS/report\_s-001',

                                p\_rep\_format        => :P3001\_REPORT\_FORMAT,

                                p\_data\_source        => 'test\_db',

                                p\_out\_filename        => 'report\_s-001',

                                p\_rep\_locale        => :G\_REPORT\_LOCALE,

                                p\_rep\_encoding        => 'UTF-8'

                                --p\_additional\_params    => :p\_additional\_params

                             );

apex_application.g_unrecoverable_error := true;

EXCEPTION

WHEN OTHERS THEN

xlog('PRC_SHOW_REPORT_TUNNEL', sqlerrm, 'ERROR');

raise;

END;

|

Taking into consideration that the same code is currently working by the same way on the previous version 5.0.4.00.12 even after upgrading the Oracle APEX and the application to the latest version, also the log files of the application server do not show any information related to this error.

Thanks & Best Regards,

Mostafa M. Abdou