[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Newbie - How to Load XML data into Oracle
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@i... [mailto:owner-xml-dev@i...]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@b... | | I take sole responsibility for any opinion expressed herein. | * * * * * | | | | xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@i... | Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ and on | CD-ROM/ISBN 981-02-3594-1 | To unsubscribe, mailto:majordomo@i... the following message; | unsubscribe xml-dev | To subscribe to the digests, mailto:majordomo@i... the | following message; | subscribe xml-dev-digest | List coordinator, Henry Rzepa (mailto:rzepa@i...) | | xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@i... Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ and on CD-ROM/ISBN 981-02-3594-1 To unsubscribe, mailto:majordomo@i... the following message; unsubscribe xml-dev To subscribe to the digests, mailto:majordomo@i... the following message; subscribe xml-dev-digest List coordinator, Henry Rzepa (mailto:rzepa@i...)
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|