Oracle PL/SQL/Data Type/httpuritype
httpUriType.createUri
<source lang="sql">
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.ru") ); 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.ru 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>
</source>
httpuritype.getUrl()
<source lang="sql">
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.ru") ); 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.ru 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>
</source>
httpuritype type column
<source lang="sql">
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.ru") ); 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.ru 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>
</source>