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@[...].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@[...].in]
>  Sent: 04 March 2002 18:01
>  To: xml-dev@[...].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>