Hi.
I'm performing a simple test using "apex_web_service.make_rest_request", in SQL Developer, but the command is returning the error "ORA-28759: failure to open file".
I'm using Oracle XE 21.2 database and I have ORDS 22.1 configured.
--------------TEST (SQL Developer)--------------
select apex_web_service.make_rest_request(
p_url => 'https://api.themoviedb.org/',
p_http_method => 'GET',
p_wallet_path => 'file:C:\Oracle\app\product\21c\dbhomeXE\data\wallet',
p_wallet_pwd => 'oracle123') from dual;
---------------------------------------------------
-----------------------RETURN-------------------
ORA-29273: HTTP request failed
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 1182
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 782
ORA-28759: failure to open file
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 756
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 1023
ORA-06512: at "APEX_220100.WWV_FLOW_WEB_SERVICES", line 1371
ORA-06512: at "APEX_220100.WWV_FLOW_WEBSERVICES_API", line 568
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.
----------------------------------------------------
--------CHECKING TRUSTED CERTS (SQL Plus)---------
SQL> $ orapki wallet display -wallet C:\Oracle\app\product\21c\dbhomeXE\data\wallet -pwd oracle123
Picked up JAVA_TOOL_OPTIONS: -Dconfig.url=C:\Oracle\ords\config -Xms1024M -Xmx1024M
Picked up JAVA_TOOL_OPTIONS: -Dconfig.url=C:\Oracle\ords\config -Xms1024M -Xmx1024M
Oracle PKI Tool Release 21.0.0.0.0 - Production
21.3.0.0.0 : Versão {1}
Copyright (c) 2004, 2021, Oracle e/ou suas empresas afiliadas. Todos os direitos reservados.
Requested Certificates:
User Certificates:
Trusted Certificates:
Subject: CN=*.themoviedb.org
Subject: OU=Starfield Class 2 Certification Authority,O=Starfield Technologies\, Inc.,C=US
Subject: CN=Kaspersky Anti-Virus Personal Root Certificate,O=AO Kaspersky Lab
Subject: CN=Microsoft RSA TLS CA 01,O=Microsoft Corporation,C=US
-----------------------------------------------------------
------------------MY CERT (Windows)------------------
-----------------------------------------------------------
------------------CHECKING SECURITY -----------------
-----------------------------------------------------------
What else should I check?