469,128 Members | 1,378 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,128 developers. It's quick & easy.

Create ordinary table out of XML Schema

Hi - I searched quite a bit now but still it seems that one topic was
never brought up on oracles xml handling (9i btw). Could anybody tell
me how it is possible to create a table out of a xml schema (I don't
care about the format the xml must have - the important thing is it
being xml)? I can add data to the table using xml, get the schema out
in xml and so on but there seems no topic that handles automatic table
creation using a xml schema (apart from a xmltype).

Best regards
Andreas Bergmeier
Jul 19 '05 #1
2 6003
"Andreas Bergmeier" <an***************@compass-systems.de> wrote in message
news:7a**************************@posting.google.c om...
Hi - I searched quite a bit now but still it seems that one topic was
never brought up on oracles xml handling (9i btw). Could anybody tell
me how it is possible to create a table out of a xml schema (I don't
care about the format the xml must have - the important thing is it
being xml)? I can add data to the table using xml, get the schema out
in xml and so on but there seems no topic that handles automatic table
creation using a xml schema (apart from a xmltype).

Best regards
Andreas Bergmeier


Andreas,

Have you read the article, "Make XML Native and Relative ", by Johnathon
Gennick at http://otn.oracle.com/oramag/oracle/03-jan/o13xml.html ? In that
article, Johnathon takes an XML schema to create object-relational tables.

Douglas Hawthorne
Jul 19 '05 #2
kamal
1
Dear sir i too looking for the same. but on opening http://www.oracle.com/technology/oramag/oracle/03-jan/o13xml.html
above link i am getting following error

Error: You do not have sufficient privileges to perform this operation. (WWC-41415)

kindly tell me the solution
Jul 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by vector | last post: by
2 posts views Thread by masri999 | last post: by
2 posts views Thread by Amber | last post: by
1 post views Thread by Andreas Bergmeier | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.