| XML to RDBMS [message #404508] |
Fri, 22 May 2009 00:59  |
deepshikhahcl
Messages: 14
Registered: October 2008
|
Junior Member |
|
|
Hi,
I have an XML. my requirment is that i have to use the xmldb so that the data that is there in the XML can be imported into the database and relations are created among them.
I have inserted the xdb tags but somehow tables are not created.
below is the xsd that i am using.
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified" xdb:storeVarrayAsTable="tr
ue">
<xs:element name="UserDB" xdb:defaultTable="USERDB">
<xs:annotation>
<xs:documentation>Comment describing your root element</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="User" xdb:SQLName="User">
<xs:complexType>
<xs:sequence>
<xs:element name="Roles" xdb:SQLName="Roles">
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="Role" xdb:SQLName="Role" >
<xs:complexType>
<xs:attribute name="Name" xdb:SQLName="NAME" xdb:SQLType="VARCHAR2"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="NodeAccess" xdb:SQLName="NodeAccess">
<xs:complexType>
<xs:sequence maxOccurs="unbounded">
<xs:element name="Node" minOccurs="0" xdb:SQLName="Node">
<xs:complexType>
<xs:attribute name="name" xdb:SQLName="NAME" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="nodeId" xdb:SQLName="NODEID" xdb:SQLType="NUMBER"/>
<xs:attribute name="nodeName" xdb:SQLName="NODENAME" xdb:SQLType="VARCHAR2"/>
</xs:complexType>
</xs:element>
<xs:element name="Level" minOccurs="0" xdb:SQLName="Level">
<xs:complexType>
<xs:attribute name="name" xdb:SQLName="NAME" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="levelId" xdb:SQLName="LEVELID" xdb:SQLType="VARCHAR2"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="eid" xdb:SQLName="EID" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="description" txdb:SQLName="DESCRIPTION" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="firstName" xdb:SQLName="FNAME" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="lastName" xdb:SQLName="LNAME" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="email" xdb:SQLName="EMAIL" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="phoneNumber" xdb:SQLName="PHONE" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="faxNumber" xdb:SQLName="FAX" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="country" xdb:SQLName="COUNTRY" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="status" xdb:SQLName="STATUS" xdb:SQLType="VARCHAR2"/>
<xs:attribute name="userAccessLevel" xdb:SQLName="USERACCESSLEVEL" xdb:SQLType="VARCHAR2">
<xs:annotation>
<xs:documentation>"Global" for Global access, "Market" for Market Access and "$Level Name$" for Market specific Level Access</xs:documentation>
</xs:annotation>
</xs:attribute>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="UserDBDate" xdb:SQLName="USERBDATE" xdb:SQLType="DATE"/>
<xs:attribute name="UserDBTime" xdb:SQLName="USERBTIME" xdb:SQLType="DATE"/>
</xs:complexType>
</xs:element>
</xs:schema>
|
|
|
|
| Re: XML to RDBMS [message #404530 is a reply to message #404508] |
Fri, 22 May 2009 02:23  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| deepshikhahcl wrote on Fri, 22 May 2009 07:59 | I have inserted the xdb tags but somehow tables are not created.
|
Care to elaborate on that?
What exactly did you do with this xsd?
Show us the steps that you took & the response Oracle gave you. Preferrably by copy-paste of your sqlplus session.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
