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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759481858, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/utl/http/index(123): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78