Reading XML file from Server

[Sandeep Awasthi]

Hello Everyone,

I have some data in XML file located on the server. I want to read that data and save it in Oracle table. I dont know how to do it. Can someone please help me? I am new to XML.

[Balaji Loganathan]

Moving this to XML forum, folks their might help you.
XML Forum

[Lasse Koskela]

I would start by reading up on how to parse XML files using DOM or SAX. The best place to start learning are the "Introduction to DOM" and "Introduction to SAX" tutorials at IBM developerWorks (use the search box to find them).

Once you know how to parse the XML document and pick out the pieces of data you're interested about, jump to our JDBC forum to get help on how to insert data into a database using the JDBC API.

[Sandeep Awasthi]

Thanks for your help