SQL>
SQL> create table websites
2 (client varchar2(50),
3 siteURL httpuritype);
Table created.
SQL>
SQL> insert into websites values('S',httpUriType.createUri('www.s.com') );
1 row created.
SQL>
SQL> SET LINESIZE 32767
SQL>
SQL> SET PAGESIZE 50000
SQL>
SQL> SET LONG 2000000000
SQL>
SQL> spool url
SQL> select w.siteUrl.getUrl() from websites w;
http://www.s.com
1 row selected.
SQL> spool off
SQL>
SQL>
SQL> spool website
SQL> select w.siteUrl.getClob() from websites w;
ERROR:
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
no rows selected
SQL> spool off
SQL>
SQL>
SQL>
SQL> drop table websites;
Table dropped.
SQL>