By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

Create ordinary table out of XML Schema

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"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

P: 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.