Extract data from XML online periodically.
818494Nov 30 2010 — edited Dec 1 2010Hi guys, i'm new to PL/SQL and im kind of stuck here, what i'm trying to acomplish is:
There is this file online : [indicadores.xml|http://www.dof.gob.mx/indicadores.xml] that contains some data for currency exchange rates that i need to use.
i just need to get the <item> elements.
this feed gets updated daily, so what i intend to do is to retrieve that data every day at midnight, and store the data in a simple table with the following structure:
CREATE TABLE RATES
(
title VARCHAR2( CHAR) NOT NULL ,
description NUMBER NOT NULL ,
pubDate DATE NOT NULL ,
);
i don't know if this is possible nor how, i've been checking some of the posts on this forum, but most of them parse a local XML file and not an online one, also i don't know how can i do it on a daily basis.
Any help will be greatly appreciated!
Thanks!
José Manuel Hurtado Portugal