Have a stored procedure using APEX_WEB_SERVICE pkg that web call to first get OAuth token then make request to URI. Code works fine in dev with same exact db and apex version as prod but doesn't run in prod. Adding certificate info makes no difference. In dev w/o cert parameters, works fine as well with. ACL is exactly same on both databases. Difference between databases is prod is on RAC, dev is not.
Dev:
SQL> set serveroutput on
SQL> begin
2 -- authenticate client
3 apex_web_service.oauth_authenticate (
4 p_token_url => 'https://******/as/token.oauth2'
5 , p_client_id => '**************'
6 , p_client_secret => '**************'
7 , p_wallet_path => null
8 , p_wallet_pwd => null
9 );
10 -- setup headers to use the token
11 dbms_output.put_line(apex_web_service.g_oauth_token.token);
12 end;
13 /
56Boo5wDhm7IbPOKhWy0DX7PjuB9
PL/SQL procedure successfully completed.
Prod:
SQL> set serveroutput on
begin
-- authenticate client
apex_web_service.oauth_authenticate (
p_token_url => 'https://*****/as/token.oauth2'
, p_client_id => '*********'
, p_client_secret => '**************'
, p_wallet_path => null
, p_wallet_pwd => null
);
-- setup headers to use the token
dbms_output.put_line(apex_web_service.g_oauth_token.token);
end;
/
SQL> 2 3 4 5 6 7 8 9 10 11 12 13 begin
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-28759: failure to open file
ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 533
ORA-06512: at "APEX_180200.WWV_FLOW_WEBSERVICES_API", line 472
ORA-06512: at line 3