APEX webservice references and ACL

When you upgrade your APEX installation on an Oracle 11g database, you might get network access problems like not being able to send email or create a web service reference. This is because the ACL (access control list) has not been well configured.

The Oracle 11g database is shipped with APEX 3.01 pre-installed. This APEX installation resides in schema FLOWS_030000. In order to be able to communicate over the Internet, this user gets the connect and the resolve privileges which can be granted with the package dbms_network_acl_admin. After upgrading, the APEX installation will reside in the APEX_030200 schema. This is a new created user and does not yet have the connect and the resolve privileges by default!

To grant connect privileges to a host for the APEX_030200 user, execute the following script:

4 comments on “APEX webservice references and ACL”

Hi,
I tried to implement the sample in your Apex 4.0 cookbook for Google Maps and cannot get the map to show. Do you have any errata or any changes to share that could help in getting the example to work? I have tried it on a couple different Apex environments and cannot get the map to show. Any suggestions on diagnosing the problem?

This code has not been tested!! How is it possible to post such a piece of code (under the name of a consulting company in IT services) here??
By the way, in practice, the parameter principal might not have the value as given above… it will be a quite wrong application design.
The commit should be issued outside of the PL/SQL block ini order to catch through an exception the posible errors or lack of permissions.

You might not have noticed, this blog was written 4 years ago specifically for a now very old version of APEX in combination with the 11g database.
I’m guessing you are now running a higher version of APEX. It’s true that for newer version of APEX (and the database) this code will not work.

I can assure you that the code has been tested and found working perfectly at the time this blog was written.
Do you mind telling us what you are trying to accomplish? We might be able to offer you another solution for you situation.