Search notes:

Oracle: UTL_HTTP

declare
   req    utl_http.req ;
   res    utl_http.resp;
   txt    varchar2(32001);
begin

   req := utl_http.begin_request('http://renenyffenegger.ch/');
   res := utl_http.get_response(req);

   begin loop
      utl_http.read_text(res, txt, 32000);
      dbms_output.put_line(txt);

      end loop;
   exception when utl_http.end_of_body then
      utl_http.end_response(res);
   end;

end;
/

Procedures and functions

add_cookies
begin_request
clear_cookies
close_persistent_conn
close_persistent_conns
create_request_context
destroy_request_context
end_request
end_response
get_authentication
get_body_charset
get_content_encoding_support
get_cookies
get_cookie_count
get_cookie_support
get_detailed_excp_support
get_detailed_sqlcode
get_detailed_sqlerrm
get_follow_redirect
get_header
get_header_by_name
get_header_count
get_persistent_conns
get_persistent_conn_count
get_persistent_conn_support
get_proxy
get_response
get_response_error_check
get_transfer_timeout
read_line
read_raw
read_raw_ptr
read_text
request
request_pieces
set_authentication
set_authentication_from_wallet
set_body_charset
set_content_encoding_support
set_cookie_support
set_cookie_support
set_detailed_excp_support
set_follow_redirect
set_header
set_persistent_conn_support
set_property
set_proxy
set_response_error_check
set_transfer_timeout
set_wallet
write_line
write_raw
write_text

See also

Oracle UTL packages
dbms_network_acl_admin allows to modify access control lists (ACLs) which control access to external network services.
ORA-24247: network access denied by access control list (ACL)
ORA-29273: HTTP request failed

Index