RE: XML to Oracle
We also had such requirement. We had parsed the XML file to create a loadable text file and used loader via simple Java program. Regards, Dipankar --- "Anderson, John" <John@B...> wrote: > 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@y...] > Sent: 04 March 2002 18:01 > To: xml-dev@l... > Subject: 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. > ===== DIPANKAR CHAKRABARTI My Home Page: www.geocities.com/dipanc Net-union homepage: www.geocities.com/dipanc/ScCollege1987.html __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format