Running Oracle Database 12c Enterprise Edition Release 18.104.22.168.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?