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@Barbadosoft.com> 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@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.
>
=====
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/
-----------------------------------------------------------------
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>
