Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extract data from XML online periodically.

818494Nov 30 2010 — edited Dec 1 2010
Hi 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
This post has been answered by MichaelS on Dec 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2010
Added on Nov 30 2010
11 comments
630 views