How to call HTTPS Url Without SSL Wallet in 19c Mustafa, 2025-04-06 Hi, as you know for over the years, if you want to call a secure url (https) you must add the certificates to your ssl wallet first. this operation, most probably, requires also DBA action. Finally with 23ai changed this and now you can call a https url without wallet. How about 19c? Do you know that you can do this on 19c too? at least 19.24 and above! you just need to set your wallet as “system:” SQL> select banner_full from v$version; BANNER_FULL ---------------------------------------------------------------------------------------------------------------------------------------------------------------- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.24.0.0.0 declare 2 req utl_http.req; 3 res utl_http.resp; 4 begin 5 req := utl_http.begin_request('https://google.com', 'POST'); 6 end; 7 / declare * ERROR at line 1: ORA-29273: HTTP request failed ORA-29024: Certificate validation failure ORA-06512: at "SYS.UTL_HTTP", line 380 ORA-06512: at "SYS.UTL_HTTP", line 1148 ORA-06512: at line 5 SQL> declare 2 req utl_http.req; 3 res utl_http.resp; 4 begin 5 UTL_HTTP.SET_WALLET('system:', NULL); 6 req := utl_http.begin_request('https://google.com', 'POST'); 7 end; 8 / PL/SQL procedure successfully completed. 1234567891011121314151617181920212223242526272829303132333435 SQL> select banner_full from v$version; BANNER_FULL----------------------------------------------------------------------------------------------------------------------------------------------------------------Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.24.0.0.0 declare 2 req utl_http.req; 3 res utl_http.resp; 4 begin 5 req := utl_http.begin_request('https://google.com', 'POST'); 6 end; 7 /declare*ERROR at line 1:ORA-29273: HTTP request failedORA-29024: Certificate validation failureORA-06512: at "SYS.UTL_HTTP", line 380ORA-06512: at "SYS.UTL_HTTP", line 1148ORA-06512: at line 5 SQL> declare 2 req utl_http.req; 3 res utl_http.resp; 4 begin 5 UTL_HTTP.SET_WALLET('system:', NULL); 6 req := utl_http.begin_request('https://google.com', 'POST'); 7 end; 8 / PL/SQL procedure successfully completed. as you can see, after setting wallet as ‘system:’ it works as expected. cheers, 19c 21c 19chttpsssl walletwithout wallet
Can you explain more about how the wallet setting as ‘system:’ works in 19c? Does it require any additional configurations? Reply
Hi, no it doesn’t require anything at all! that is the beauty. it uses OS cert management I assume but as I said you must be at certain RU (probably 19.24 and above) Reply