Use UTL_HTTP package to load a website to a table : UTL_HTTP « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. UTL_HTTP

Use UTL_HTTP package to load a website to a table

 

set serveroutput on size 200000


CREATE TABLE http_results (
  sequence_no NUMBER PRIMARY KEY,
  piece VARCHAR2(2000));
  
DECLARE
  myResult UTL_HTTP.HTML_PIECES;
  v_URL VARCHAR2(100) := 'http://www.oracle.com';
  v_Proxy VARCHAR2(100) := 'YOUR_PROXY_SERVER';
BEGIN
  myResult := UTL_HTTP.REQUEST_PIECES(v_URL, 10, v_Proxy);
  FOR v_Count IN 1..10 LOOP
    INSERT INTO http_results VALUES (v_Count, myResult(v_Count));
  END LOOP;
END;
/

SELECT * FROM http_results
  ORDER BY sequence_no;
  
DROP TABLE http_results;
 


--

 

Related examples in the same category