httpuritype.getUrl() : httpuritype « Data Type « Oracle PL / SQL

1. Oracle PL / SQL
2. Data Type
3. httpuritype

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.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>

   
  

Related examples in the same category