Is the schema definition always the same? What version, 10g has lots of new
xml stuff. I've only worked with 9i.
Here's what we did
Load the xml document into an xmltype column. Loop through each record in
your database containing the xmltype column. Check for the existence of each
xml attribute. If you can have more than one occurrence of the attribute,
you have to check for that and loop through those. It's a lot of code and
very inflexible, but when they design an ordering system somebody should
have figured out that people might actually want to be able to report on the
details of the orders.
You can load the schema definition into the database and then automatically
load the xml into the proper tables and columns but this was not practical
for our purposes.
go to asktom.oracle.com and do a search on xml to get started.
----- Original Message -----
From: "Bjørn Dörr Jensen" <B.D.Jensen_at_gmx.net>
To: <oracle-l_at_freelists.org>
Sent: Monday, September 26, 2005 2:42 PM
Subject: XML -> DDL / DML
> Hi!
> I have to take a xml-document through a web-service.
> Are there tools to generate table-ddl's?
> The xml-document should be "converted", e.g. stored in a set of
(normalized)
> tables.
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 26 2005 - 14:15:56 CDT
