Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

how to create xlib_jasperreports packgae #45

#1

when i call report from oracle apex using below code getting error
ORA-06550: line 6, column 1: PLS-00201: identifier 'XLIB_JASPERREPORTS.SET_REPORT_URL' must be declared

DECLARE
l_additional_parameters varchar2(32767);

begin

xlib_jasperreports.set_report_url('http://localhost:8080/jri/report');

xlib_jasperreports.show_report(p_rep_name=>'Test1',
p_rep_format=>'pdf',
p_data_source=>'APPS',
p_rep_locale='en-US',
p_out_filename='Test1.PDF'
);
apex_application.g_unrecoverable_error:='true';
end;

  • replies 2
  • views 1.2K
  • likes 0
#2

Move to SQL folder in the Jasper Report Integration (jri) folder and execute the script(user_install.sql) on Oracle Command prompt; this will install all the required object to run the Jasper report from APEX.

Do you still have this problem, @farooqmalik ?
Seems to be an installation issue.
Please comment.
Thank you.