I am migrating to a 19c base cloud db
Apex Version 24.2.6
I copied my wallet to the server and set the permissions
I am using the same wallet path and password in both utl_http and that I put in apex admin
This snippet below works and provides an output
declare
v_output clob;
begin
UTL_HTTP.set_wallet('file:///u01/app/oracle/ApexWallet', 'xxxxx');
SELECT utl_http.request('https://testurl.com') into v_output FROM dual;
dbms_output.put_line(v_output);
end;
The next snippet gives an error
declare
v_output clob;
begin
select apex_web_service.make_rest_request(
p_url => 'https://testurl.com',
p_http_method => 'GET')
into v_output from dual;
dbms_output.put_line(v_output);
end;
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES", line 681
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1004
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 650
ORA-28759: failure to open file
If I override my apex_web_service.make_rest_request with p_wallet_path and p_wallet_pwd. I get a response
Any suggestions? Need a solution ASAP