XML tables and XML views.
Hello:
I would like to get a table and actualze it everyday with the change of € and other moneys.
I know I'm doing something wrong but I don't know what it is.
This is I have done:
1. Create a table like this:
create table diruak (url URIType);
2. Insert data:
insert into diruak VALUES (HTTPURIType.createURI(http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml);
3. Read the data inserted.
select url.getClob() from diruak;
select url.getURL() from diruak;
4. After this I try to get data using EXTRACT and EXTRACTVALUE functions and I can't get anything.
Thanks in advance. bye
I would like to get a table and actualze it everyday with the change of € and other moneys.
I know I'm doing something wrong but I don't know what it is.
This is I have done:
1. Create a table like this:
create table diruak (url URIType);
2. Insert data:
insert into diruak VALUES (HTTPURIType.createURI(http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml);
3. Read the data inserted.
select url.getClob() from diruak;
select url.getURL() from diruak;
4. After this I try to get data using EXTRACT and EXTRACTVALUE functions and I can't get anything.
Thanks in advance. bye
0