Re: loading xml into oracle

Hi,  

Actually, we are regularly loading txt files and csv files into oracle by sing unix shell script which calls sqlloader.  

But we are getting some issues with that.  

So is tehre any better way i am thinking. Somebody told that loading xml files into oracle will be easy and data will be more consistent.  

Just chekcing this.  

The whole story is : we get the data from clients in either txt file or csv (comma seperated value) file. Based on the positions the data will be loaded. (the posistions are predefined).  

However, sometimes the positions are getting changed (by client). It is not in our control.  

Not sure is there any better way sending the flat files into oracle (even if the positions are keep getting changed).  

Any thoughts would be of great help for me.  

Thanks,
Raj

GovindanK <gkatteri_at_fastmail.fm> wrote:
What is the type of XML file you intend to use? Is it going to stored as XMLTYPE datatype? How about Selecting from an External table?

On Fri, 26 Aug 2005 16:55:01 -0700 (PDT), "raja rao" said:
> Hi All,
>
> Is there any tool to load xml file into oracle database. (is it sqlloader
> ? or any other 3rd party softwares available .)
>
> Thanks,
> Raj
>
>
> ---------------------------------
> Start your day with Yahoo! - make it your home page

--
http://www.freelists.org/webpage/oracle-l

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l