Posts

Showing posts from May, 2012

Oracle HTTP Requests: Set up the ACL

In order to use utl_http requests from Oracle 11g onward (or any network services for that matter), you need to set up an ACL. Two generic permissions to grant are connect and resolve, where * can be used as a wild card. A good template I commonly use, just replacing the file name and schema name. This should be executed as a user with dba privileges. DECLARE l_filename varchar2(200) := 'file_test_http.xml'; l_schema varchar2(200) := 'FILE_TEST'; BEGIN BEGIN DBMS_NETWORK_ACL_ADMIN.DROP_ACL( acl => l_filename ); EXCEPTION WHEN OTHERS THEN NULL; -- ACL does not exist yet END; DBMS_NETWORK_ACL_ADMIN.CREATE_ACL( acl => l_filename , description => 'All requests to test utl_http' , principal => l_schema -- schema name , is_grant => TRUE , privilege => 'connect' );

End User's Guide

Just noticed this on the documentation index. Apex now has an end users guide:  http://docs.oracle.com/cd/E23903_01/doc/doc.41/e26811/toc.htm I'm not yet certain it's a good idea linking users to this documentation in any user guides you create for your apps, given Oracle seems to like changing the structure of their links every couple of years, leaving documentation links that no longer work. Even so, it's worth knowing :-) Current sections include: About Oracle Application Express Using Websheets Using Interactive Reports About Uploading Data