Oracle PL/SQL/Data Type/httpuritype

Материал из SQL эксперт
Перейти к: навигация, поиск

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>