Hi All.
I'm using Apex 23.1.
I´m following this link in order to create my first working Oracle Wallet:
https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/6121/index-en.html
I already created create the wallet and added the certificate in place:
c:\webFIGO\OracleWallet>orapki wallet create -wallet https_wallet -pwd Oradba12c -auto_login
Picked up _JAVA_OPTIONS: -Dconfig.url=C:\ords\config
Picked up _JAVA_OPTIONS: -Dconfig.url=C:\ords\config
Oracle PKI Tool Release 21.0.0.0.0 - Production
21.3.0.0.0: Versión {1}
Copyright (c) 2004, 2021, Oracle y/o sus subsidiarias. Todos los Derechos Reservados.
La operación se ha realizado correctamente.
c:\webFIGO\OracleWallet>orapki wallet add -wallet https_wallet -cert "DigiCert Global Root G2.crt" -trusted_cert -pwd Oradba12c
Picked up _JAVA_OPTIONS: -Dconfig.url=C:\ords\config
Picked up _JAVA_OPTIONS: -Dconfig.url=C:\ords\config
Oracle PKI Tool Release 21.0.0.0.0 - Production
21.3.0.0.0: Versión {1}
Copyright (c) 2004, 2021, Oracle y/o sus subsidiarias. Todos los Derechos Reservados.
La operación se ha realizado correctamente.
Also, I configured Apex an the Instance for wallet:
However I´m not being able to make the request:
select apex_web_service.make_rest_request(
p_url => 'https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_day.geojson',
p_http_method => 'GET',
p_wallet_path => 'file:///C:/webFIGO/OracleWallet/https_wallet' ) from dual;
ORA-29273: fallo de la solicitud HTTP
ORA-06512: en "APEX_230100.WWV_FLOW_WEB_SERVICES", línea 1325
ORA-06512: en "APEX_230100.WWV_FLOW_WEB_SERVICES", línea 897
ORA-28759: fallo al abrir el archivo
ORA-06512: en "SYS.UTL_HTTP", línea 380
ORA-06512: en "SYS.UTL_HTTP", línea 1148
ORA-06512: en "APEX_230100.WWV_FLOW_WEB_SERVICES", línea 883
ORA-06512: en "APEX_230100.WWV_FLOW_WEB_SERVICES", línea 1170
ORA-06512: en "APEX_230100.WWV_FLOW_WEB_SERVICES", línea 1514
ORA-06512: en "APEX_230100.WWV_FLOW_WEBSERVICES_API", línea 581
ORA-06512: en línea 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.
Clearly the error seems to be related to not being able to find the wallet info.
I've performed several tests chaging p_wallet_path :
p_wallet_path => 'file:///C:/webFIGO/OracleWallet/https_wallet'
p_wallet_path => 'file:/C:/webFIGO/OracleWallet/https_wallet'
p_wallet_path => 'file:C:\webFIGO\OracleWallet\https_wallet'
That is using / \ slashes, but nothing works !
This is the path on local file system:
C:\webFIGO\OracleWallet\https_wallet
Also I do not see any access permission on that folder:
Can anyone provide some help on this please?.
Thanks so much in advance !!!