generate DDL from XML Schema
249698Aug 25 2007 — edited Aug 27 2007Hi,
After fighting hard with Ora Dokus and millions tips from the web, I can not find any reasonable guide to show how to continue after XML-Schema generating onto creating a relational table from the metadata as covered in the XML-Schema.
Isn't there a function/procedure in 1 of those DBMS_XML.... packages ?
Where is a guide, telling the whole lifecycle of which procedure to use in what order, to read metadata from registered XML-Schema -> generate DDL -> load XML-Document into the created table ?
All dokus and samples stop after creating a CLOB from XML-Document. why ?
Does nobody want to laod the XML-Document into a relational table ?
All sample-code generates "create table ...." statment manually !?? , even so they call themself as tutorial "from XML-Document ro object-relational table' !
the discusion board here contains dozends of threads dealing with generating XML from relatinoal table ! A theme, which seems to be well documented in the Oracle-Docus, as far as I see.
I need the reverse wazy and wonder, if I am the only one want to do it that way ?
Million thanks for saving my poor left hair by telling any tip.
Lao De