Oracle PL/SQL/Data Type/httpuritype

Материал из SQL эксперт
Версия от 09:58, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

httpUriType.createUri

 
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>



httpuritype.getUrl()

 
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>



httpuritype type column

 

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>
Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL/Data_Type/httpuritype&oldid=1528»