Forum Stats

  • 3,770,464 Users
  • 2,253,118 Discussions
  • 7,875,466 Comments

Discussions

How on earth to get this lab to work?


The error is

ORA-29273: HTTP request failed ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1157 ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 757 ORA-29024: Certificate validation failure ORA-06512: at "SYS.UTL_HTTP", line 380 ORA-06512: at "SYS.UTL_HTTP", line 1148 ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 735 ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 998 ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1413 ORA-06512: at "APEX_200200.WWV_FLOW_WEBSERVICES_API", line 655 ORA-06512: at line 5


And I tried to import the certs into a wallet and it still complains:

declare 

  l_blob blob;

begin

   

l_blob := apex_web_service.make_rest_request_b(

    p_url => 'https://raw.githubusercontent.com/TheEconomist/big-mac-data/master/source-data/big-mac-source-data.csv', 

  p_http_method => 'GET', 

  p_wallet_path => 'file:/u02/wallet/github',

  p_wallet_pwd => 'Welcome1!', 

  p_https_host => 'www.github.com');


end;