Databases Reference
In-Depth Information
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => 'print_service.xml',
principal => 'APEX_040100',
is_grant => true,
privilege => 'resolve');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => 'print_service.xml',
host => 'localhost',
lower_port => 8888,
upper_port => 8888);
COMMIT;
END;
/
(The preceding script is using APEX version 4.1.1.)
You can read more at
http://docs.oracle.com/cd/B28359_01/appdev.111/
b28419/d_networkacl_adm.htm
.
Failing to grant these privileges will result in issues with PDF/report printing.
Speciically, you will get the following error message:
ORA-20001: The printing engine could not be reached because either the
URL specified is incorrect or a proxy URL needs to be specified
To test a simple report against the Apache FOP report server, perform the
following steps:
1.
Create a simple report and enable report printing.
2.
For the
Report
region under the
Print
tab, select
Yes
for
Print enabled
and
create a link label name.
3.
Run the report and test the printing.
