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>