Use a SYS.HttpUriType value to retrieve a message from a URL : HttpUriType « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. HttpUriType

SQL>
SQL>
SQL> DECLARE
  2     WebPageURL sys.HttpUriType;
  3     WebPage CLOB;
  4  BEGIN
  5     WebPageURL := SYS.HttpUriType.createUri('http://g.com/');
  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>