Here is the Plsql ( pl/sql) Procedure which collects / gets / scrap some Data / content from External Website :
CREATE OR REPLACE PROCEDURE download_html_to_clob (p_url IN VARCHAR2) AS
l_clob CLOB;
BEGIN
-- Set Proxy - only if you are working
utl_http.set_proxy(proxy=>'www-proxy.us.mycompany.com:80');
-- Set character set of retrived document
--(in our example - the web page contains Hebrew content)
utl_http.set_body_charset('WINDOWS-1255');
l_clob := HTTPURITYPE.createuri(p_url).getclob();
-- Insert the data into the table.
INSERT INTO http_clob_test (id, url, data)
VALUES (http_clob_test_seq.NEXTVAL, p_url, l_clob);
END download_html_to_clob;
How to implement :begin
download_html_to_clob('http://www.google.co.il');
end;
Clob Table which will Hold HTML content received from External website :
CREATE TABLE http_clob_test ( id NUMBER(10), url VARCHAR2(255), data CLOB, CONSTRAINT http_clob_test_pk PRIMARY KEY (id) );
Sequence for that table :
CREATE SEQUENCE http_clob_test_seq;
ALL INFO APPEARS HERE THANKS TO :
http://www.oracle-base.com/articles/misc/RetrievingHTMLandBinariesIntoTablesOverHTTP.php
