Printing - Oracle APEX Best Practices - page 107

BEGIN
req := utl_http.begin_request('http://hostname:printer server
port/xmlpserver');
utl_http.set_header(req, 'User-Agent', 'Mozilla/4.0');
resp := utl_http.get_response(req);
LOOP
utl_http.read_line(resp, value, TRUE);
dbms_output.put_line(value);
END LOOP;
utl_http.end_response(resp);
EXCEPTION
WHEN utl_http.end_of_body THEN
utl_http.end_response(resp);
END;

How to check if network services
are enabled
Network services need to be enabled for Oracle RDBMS version 11 and higher.
When an error occurs in the printing, the network services need to be checked.

select acl, principal, privilege, is_grant
from dba_network_acl_privileges;

The outcome is as follows:

ACL Principal Privilege

Is_Grant
/sys/acls/power_users.xml APEX_040100 Connect

True

The preceding query will check the necessary privileges that are needed for the
printing feature in Application Express. These rows need to be present for enabling
printing. If the necessary privileges are not granted when you are printing, the
following error will be generated:

ORA-20001: The printing engine could not be reached because either the
URL specified is incorrect or a proxy URL needs to be specified

When there are no rows, ACL needs to be added. The code needed to ix this
problem is available in the Installation Guide from Application Express, under the
header 3.3.7 Enable Network Services in Oracle Database 11g ( http://docs.oracle.
com/cd/E23903_01/doc/doc.41/e21673/pre_require.htm#i1009513 ).