Oracle PL/SQL Tutorial/PL SQL Data Types/HttpUriType
Use a SYS.HttpUriType value to retrieve a message from a URL
<source lang="sql">
SQL> SQL> SQL> DECLARE
2 WebPageURL sys.HttpUriType; 3 WebPage CLOB; 4 BEGIN 5 WebPageURL := SYS.HttpUriType.createUri("http://g.ru/"); 6 7 WebPage := WebPageURL.getclob(); 8 9 DBMS_OUTPUT.PUT_LINE((SUBSTR(WebPage,1,60))); 10 END; 11 /
DECLARE
ERROR at line 1: ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1674 ORA-12545: Connect failed because target host or object does not exist ORA-06512: at "SYS.HTTPURITYPE", line 34 ORA-06512: at line 7
SQL> SQL></source>