Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

generate DDL from XML Schema

249698Aug 25 2007 — edited Aug 27 2007
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2007
Added on Aug 25 2007
4 comments
2,572 views