SET_AUTHENTICATION_FROM_WALLET call returns ACL error

0 votes

1 answer

2726 views

                          Running Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production.  Have a wallet setup containing a basic authentication credential.  
PL/sql package is executing a request over https to an external server.  The acl seems to be setup correctly, as when I issue a request as below, and do some gets, I get results back.

    D_Request_context := UTL_HTTP.CREATE_REQUEST_CONTEXT(
                                     wallet_path     => D_Path,
                                     wallet_password => NULL,
                                     enable_cookies  => FALSE
                                  );
                                     
        D_Req := UTL_HTTP.BEGIN_REQUEST(
                      url             => D_Url,
                      method          => C_METHOD,
                      http_version    => C_VERSION,
                      request_context => D_Request_context      )

If I call the same code, but include this call

       UTL_HTTP.SET_AUTHENTICATION_FROM_WALLET(
                r         => D_Req,
                alias     => 'myalias',
                scheme    => C_SCHEME,
                for_proxy => false
             ); 

I get this error:

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

So why does the call to BEGIN_REQUEST get through the ACL, but the SET_AUTHENTICATION_FROM_WALLET, gets an error?

                        

Asked by OldProgrammer (147 rep)

Nov 19, 2018, 08:39 PM
Last activity: Nov 19, 2018, 10:15 PM

SET_AUTHENTICATION_FROM_WALLET call returns ACL error

Related Questions