PL/SQL (MOSC)

MOSC Banner

error on UTL_HTTP.begin_request

edited Mar 3, 2013 8:18PM in PL/SQL (MOSC) 4 commentsAnswered ✓
I tried  to run the folowing

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center