OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   RE: [xml-dev] XML to Oracle

[ Lists Home | Date Index | Thread Index ]

Title: RE: [xml-dev] XML to Oracle

You could use SQLXML Bulk Load to load into a SQL Server database and then use DTS from there to put in the Oracle database.  But just in case you want to do this kind of thing without buying SQL Server, I would recommend at least buying Steve Meunch’s book:

http://www.amazon.com/exec/obidos/ASIN/1565926919/qid=1015269357/sr=8-1/ref=sr_8_7_1/103-9043654-8727803.  It is quite a comprehensive guide.  Chapters 5 and 12 cover a bunch of different options for loading XML files into the database, depending on what you are trying to do.

 

Joshua Allen

Microsoft WebData XML

425.705.7857

 

-----Original Message-----
From: Anderson, John [mailto:John@Barbadosoft.com]
Sent:
Monday, March 04, 2002 9:11 AM
To: 'anand_msm@yahoo.co.in'; xml-dev@lists.xml.org
Subject: RE: [xml-dev] XML to Oracle

 

Anand,

You could try XSU, which comes free with Oracle. We've successfully used it for fetching data using a servlet which takes the SELECT statement as a parameter, but I don't know how well it works for loading (ie, whether it takes care of decisions like UPDATE vs INSERT.

John

-----Original Message-----
From: Anand M [mailto:anand_msm@yahoo.co.in]
Sent: 04 March 2002 18:01
To: xml-dev@lists.xml.org
Subject: [xml-dev] XML to Oracle

 

Hi All,

I have a customer requirement to get the data from XML
formatted data file and load it into an Oracle 8
database. SQL*Loader doesn't support
this format and I'm not aware of any other means of
accomplishing this task. Does anyody have any
knowledge about the above issue? Please help me in
this regard.

Thanks and Regards
Anand M

 

________________________________________________________________________
Looking for a job?  Visit Yahoo! India Careers
      Visit http://in.careers.yahoo.com

-----------------------------------------------------------------
The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
initiative of OASIS <http://www.oasis-open.org>

The list archives are at http://lists.xml.org/archives/xml-dev/

To subscribe or unsubscribe from this list use the subscription
manager: <http://lists.xml.org/ob/adm.pl>

The information transmitted by this e-mail message is intended solely for the use of the person to whom or entity to which it is addressed. The message may contain information that is privileged and confidential.  Disclosure, dissemination, distribution, review, retransmission to, other use of or taking any action in reliance upon this information by anyone other than the intended recipient is prohibited. If you are not the intended recipient, please do not disseminate, distribute or copy this communication, by e-mail or otherwise. Instead, please notify us immediately by return e-mail (including the original message with your reply) and then delete and discard all copies of the message.

Although we have taken precautions to minimize the risk of transmitting viruses we nevertheless advise you to carry out your own virus checks on any attachment to this message. We accept no liability for any loss or damage caused by viruses.





 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS