SQL & PL/SQL

Hi,

I haven't set up an ACL in a while and I'm having trouble creating one to allow me to use Elastic Search from PL/SQL (from a 12c database).

I can call the following from a browser and I get search results: http://database.host.name.com:9200/blog/user/dilbert

I am trying to call this from PL/SQL as SYS, but using the following code I get an ACL error:

  l_clob := apex_web_service.make_rest_request(p_url   => 'http://database.host.name.com:9200/blog/user/dilbert ',
                                               p_http_method => 'PUT',
                                               p_body => p_body);

The error I get is the classic: "Network access denied by the Access Control List"

I've tried setting up an ACL but I must be doing something wrong, so I wondered if anyone could help me out.

The Oracle database and Elastic Search database are both on the same machine.

Thanks!