Newbie - How to Load XML data into Oracle

Gorden-Ozgul, Patricia E gorden at
Wed Nov 3 14:43:04 GMT 1999

I'm new to the world of SGML (not new) and XML (new) and document
processing.  I am an Oracle developer/DBA.

My understanding of the my part of the project is to load the XML data into
an Oracle database (8.x on Solaris 2.6) from which we will be creating XML
for a required data call.  The XML output will be 'passed' through multiple
DTDs based upon which type of document is represented. 

I have never worked with variable length, multiple line tagged data before.
Is anyone out there familiar with the method by which I could perform such a
load?  It looks to me like Oracle's load utility, SQL*LOADER couldn't handle
this.  To use it I'd need to convert the XML data to a delimited flat file.

Does anyone out there have any suggestions or help for me?

* * * * *
Pat Gorden-Ozgul
Database Development
Information Services Division Bldg 477
Brookhaven National Laboratory
Upton, New York   11967
(516)344-5159     gorden at

I take sole responsibility for any opinion expressed herein.
* * * * *


xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at
Archived as: and on CD-ROM/ISBN 981-02-3594-1
To unsubscribe, mailto:majordomo at the following message;
unsubscribe xml-dev
To subscribe to the digests, mailto:majordomo at the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa at

More information about the Xml-dev mailing list