Skip to Main Content
  • Questions
  • Failed to set wallet path to system:

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, SREEJU.

Asked: April 10, 2025 - 7:05 am UTC

Last updated: April 14, 2025 - 7:22 am UTC

Version: 19.3.0.0.0

Viewed 100+ times

You Asked

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.

and Connor said...

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

More to Explore

DBMS_OUTPUT

More on PL/SQL routine DBMS_OUTPUT here