Re: Quick XML Question

It depends on how you would like the data stored. If you are simply looking to store the XML document as a chunk, then you can load the data into a clob. If you wish to load the data into a relational model, then you don't necessarily need to add any tools to Oracle, but you will need an application layer to act as interface between the XML and the underlying relational model.

You can use Java as an interface to load XML into Oracle, and there are plenty of good widgets out on the net. However, you can use Perl, C, C++, VB and anything else that can handle a protocol for ending and receiving XML messages. The SOAP libraries are fairly popular.

Technet has five different tool kits for moving XML in and out of Oracle:

http://technet.oracle.com/software/content.html

The sample code library contains sever samples you can use to get started with:

http://technet.oracle.com/sample_code/content.html

Good Luck!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Chris Weiss
mailto:chris_at_hpdbe.com
www.hpdbe.com
High Performance Database Engineering
Available for long and short term contracts


"Tim" <tim_j_not-this-bit_obviously_odonnell_at_hotmail.com> wrote in message
news:3ssA8.5181$C5.1341918_at_monolith.news.easynet.net...


>

> How can I load support for XML into an Oracle 8i database?  Do I have to

> load Java as well?

>

>

>

>