I have installed Oracle Apex on my local Oracle Database XE edition (21C).
I am working on a demo application where I need to make a SOAP webservice call and to do so, I am using apex_web_service.make_request API.
I have created ACL entry using below code.
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect','resolve'),
principal_name => 'APEX_230200',
principal_type => xs_acl.ptype_db
)
);
END;
Created a wallet where I have added the certificates of the target system using below code.
orapki wallet create -wallet D:\OracleWallet -auto_login -pwd Welcome#123
orapki wallet add -wallet D:\OracleWallet -trusted_cert -cert DigiCertGlobalRootCA.crt -pwd Welcome123
orapki wallet add -wallet D:\OracleWallet -trusted_cert -cert DigiCertTLSRSASHA2562020CA1.crt -pwd Welcome123
After this when I am making the webservice call using below code, I am still getting error.
select utl_http.request('https://www.oracle.com') from dual;
Error:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1530
ORA-28759: failure to open file
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1470
ORA-06512: at line 1
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
Fix the error and retry the HTTP request.