error on UTL_HTTP.begin_request
SQL> set serveroutput on
declare
l_http_request UTL_HTTP.req;
l_http_response UTL_HTTP.resp;
l_text VARCHAR2(1000);
p_url VARCHAR2(500) := 'https://x/x/x';
BEGIN
SQL> 2 3 DBMS_OUTPUT.enable(1000000);
4 5 6 7 8
9 DBMS_OUTPUT.put_line('Before set_wallet');
10 UTL_HTTP.set_wallet('file:/app/oracle/x/x/x', 'WalletPasswd123');
11
12 DBMS_OUTPUT.put_line('Before begin_request');
13 l_http_request := UTL_HTTP.begin_request(p_url);
14
15 DBMS_OUTPUT.put_line('Before get_response');
16 l_http_response := UTL_HTTP.get_response(l_http_request);
17 LOOP
18 DBMS_OUTPUT.put_line('Before read_text');
19 UTL_HTTP.read_text(l_http_response, l_text, 999);