Newbie - How to Load XML data into Oracle

[Steve Muench]

See the "OracleXMLSave" class & utility
provided with the "Oracle XML SQL Utilities
for Java". Combined with transformations,
this provides the ability to easily get
XML data into the database on your terms.

http://technet.oracle.com/tech/xml

thanks.

______________________________________________
Steve Muench
Consulting Product Manager & XML Evangelist
Business Components for Java Development Team

| -----Original Message-----
| From: owner-xml-dev at ic.ac.uk [mailto:owner-xml-dev at ic.ac.uk]On Behalf Of
| Gorden-Ozgul, Patricia E
| Sent: Wednesday, November 03, 1999 6:40 AM
| To: 'XML-DEV LIST'
| Subject: Newbie - How to Load XML data into Oracle
|
|
| 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?
| TIA
|
| * * * * *
| Pat Gorden-Ozgul
| Database Development
| Information Services Division Bldg 477
| Brookhaven National Laboratory
| Upton, New York   11967
| (516)344-5159     gorden at bnl.gov
|
| I take sole responsibility for any opinion expressed herein.
| * * * * *
|
|
|
| xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at ic.ac.uk
| Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ and on
| CD-ROM/ISBN 981-02-3594-1
| To unsubscribe, mailto:majordomo at ic.ac.uk the following message;
| unsubscribe xml-dev
| To subscribe to the digests, mailto:majordomo at ic.ac.uk the
| following message;
| subscribe xml-dev-digest
| List coordinator, Henry Rzepa (mailto:rzepa at ic.ac.uk)
|
|


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