Hi,
While listening through the video "Developer Coaching - Oracle Database 23ai - Zero Slides, Zero Marketing, 100% Live Demo" there mentioned that we can set the oracle wallet path to system: to access the windows level certificates, but when I tried the same using below PLSQL code, I couldn't succeed, I'm getting the error "ORA-29248: an unrecognized WRL was used to open a wallet".
Kindly let me know where I went wrong with the code? and how to use the system: as mentioned?
Oracle Database: 19.3.0.0.0
Error: ORA-29248: an unrecognized WRL was used to open a wallet
Command Used: utl_http.set_wallet('system:',null);
full code is given below:
declare
p_url varchar2(200) := 'https://www.oracle.com';
l_http_request utl_http.req;
l_http_response utl_http.resp;
l_text varchar2(32767);
begin
utl_http.set_wallet('system:',null);
l_http_request := utl_http.begin_request(p_url);
l_http_response := utl_http.get_response(l_http_request);
utl_http.read_text(l_http_response,l_text,32766);
dbms_output.put_line(substr(l_text,1,100));
exception
when utl_http.end_of_body then
utl_http.end_response(l_http_response);
end;
Thanks for your support in advance.
Not on 19.3, you need to be on one of the later release updates (we're currently up to 19.26)
I'm sorry I don't know the exact release update number, because UTL_HTTP is just a layer on top of low level C api's , so I can't see any references to the term "system:" in the PLSQL layer.
If I had to *guess*, I'd say around the 19.20 timeframe, but as always, if you were going to patch, you would patch to the latest anyway