2 Replies Latest reply on Jul 18, 2019 11:33 AM by EzequielFGA

    APEX_WEB_SERVICE.make_rest_request throws ACL error

    3784435

      Hello,

      I'm trying to call external clients data into local client using JSON parsing in apex.

       

      Here is code

      select APEX_WEB_SERVICE.make_rest_request(

      p_url => 'https://*.clientname.com',

      p_http_method => 'GET',

      p_wallet_path => 'file:///home/oracle/mywallet',

      p_wallet_pwd => 'TestC3#1')from dual;

       

      but it throws ,

      ORA-29273: HTTP request failed

      ORA-06512: at "SYS.UTL_HTTP", line 1130

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

      ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1017

      ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1523

      ORA-06512: at "APEX_180200.WWV_FLOW_WEBSERVICES_API", line 369

       

      How to resolve it apex version 5,oracle 11g

        • 1. Re: APEX_WEB_SERVICE.make_rest_request throws ACL error
          athaks

          Additionally, utl_http.request works:

           

          select utl_http.request('http://ipinfo.io/json') from dual;

           

          but apex_web_service.make_rest_request does not:

           

          select apex_web_service.make_rest_request(
                   p_url         => 'http://ipinfo.io/json',
                   p_http_method => 'GET' ) from dual;

          Error report -

          ORA-29273: HTTP request failed

          ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1017

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

          ORA-06512: at "SYS.UTL_HTTP", line 380

          ORA-06512: at "SYS.UTL_HTTP", line 1148

          ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 917

          ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1523

          ORA-06512: at "APEX_180200.WWV_FLOW_WEBSERVICES_API", line 369

          ORA-06512: at line 1

          • 2. Re: APEX_WEB_SERVICE.make_rest_request throws ACL error
            EzequielFGA

            Hi.

            I have the same problem.

            Have you had any solution?