I wonder if anyone who has gone through Trent's blog here and has the same problem as I do with the certificate: https://apextips.blogspot.com/2016/02/accepting-payments-with-stripe-in-apex_26.html?showComment=1520823490337#c6235154934728265980
I can't get pass this stage:
begin
utl_http.set_Wallet( path => 'file:/u01/app/oracle/product/12.2/db_1/wallets/stripe' , password => 'mypassword' );
output_html('https://api.stripe.com');
end;
/
I get the following error:
Error report -
ORA-29273: HTTP request failed
ORA-06512: at "HR.OUTPUT_HTML", line 25
ORA-28750: unknown error
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1127
ORA-06512: at "HR.OUTPUT_HTML", line 7
ORA-06512: at line 6 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.
I'm using a virtualbox with APEX, config is here (so oracle 12c): http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
I have tried all the certificate nodes in https://blog.hazrulnizam.com/openssl-workaround-oracle-xe-wallet/ but still no luck Also for some reason, even though I'm using Oracle 12c, I have received the ACL errors so I ran your ACL statements to get past it.
select UTL_HTTP.get_detailed_sqlerrm from dual; only returns
ORA-28750: unknown error