2 Replies Latest reply: Mar 1, 2013 9:33 AM by user11938516 RSS

    HR User, REST example - network access denied by access control list (ACL)

    user11938516
      Hi,

      I am new to APEX and am running the 'Oracle Developer Days' vm. I'm logged into APEX as the default HR/oracle account and I've been following the 'Creating and Using a RESTful Web Service in Application Express 4.2' training video, however when I try to retrieve information by entering a dept no. and clicking submit I get:

      ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-24247: network access denied by access control list (ACL)

      I've seen the following thread:

      ORA-24247: network access denied by access control list (ACL)error-UTL_HTTP

      and I've tried running the command:

      GRANT EXECUTE ON SYS.UTL_HTTP TO HR;

      but I'm not getting anywhere, presumably the HR user does not have permissions to access 'http://localhost:8888/apex/hr/employee_test'

      Any help much appreciated, also if this is the wrong forum for this question please let me know.

      Many Thanks