| How would you register the XML schema - attached [message #92396] |
Tue, 29 June 2004 11:14 |
jt
Messages: 3
Registered: December 2000
|
Junior Member |
|
|
I have 2 XSD files - newbie to ORacle 9r2 XML DB. I would like to register the XML schema but do not know how to approach doing that in XML DB. Vendor provided 2 xsd's.
I believe BDT.xsd should be registered first as it call data.xsd - but how do I go about this in Oracle?
Thanks in advance for any help!
Sorry format disappeared when I copied
First XSD - BDT.XSD
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema targetNamespace="http://namespaces.group.com/mds/bdt" xmlns:pps="http://namespaces.group.com/mds/bdt" xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:include schemaLocation="./Data.xsd"/>
<xs:element name="ENTER_NAME_OF_ROOT_ELEMENT_HERE">
<xs:annotation>
<xs:documentation>Comment describing your root element</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="BulkDataTransfer">
<xs:annotation>
<xs:documentation>Top element in a data transfer document</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element name="Policies" type="pps:PoliciesType"/>
</xs:sequence>
<xs:attribute name="IllustMode" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="inforce"/>
<xs:enumeration value="proposal"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="GroupID" type="xs:string" use="optional"/>
</xs:complexType>
</xs:element>
<xs:complexType name="PoliciesType">
<xs:annotation>
<xs:documentation>Defines a collection of policy objects for bulk transfer purposes</xs:documentation>
</xs:annotation>
<xs:sequence>
<xs:element name="Policy" type="lps:PolicyType" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
<xs:complexType name="PolicyType">
<xs:annotation>
<xs:documentation>Defines a policy for bulk transfer purposes</xs:documentation>
</xs:annotation>
<xs:complexContent>
<xs:extension base="pps:IODataType">
<xs:attribute name="PolicyNumber" type="xs:string" use="required"/>
<xs:attribute name="IssueState" type="xs:string" use="required"/>
<xs:attribute name="ProductCode" type="xs:string" use="required"/>
<xs:attribute name="IssueDate" type="xs:date" use="required"/>
<xs:attribute name="ValuesDate" type="xs:date" use="required"/>
</xs:extension>
</xs:complexContent>
</xs:complexType>
</xs:schema>
2nd XSD: Data.xsd
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:complexType name="IODataType">
<xs:annotation>
<xs:documentation>Generic type for holding input data</xs:documentation>
</xs:annotation>
<xs:sequence>
<xs:element name="IOData" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="Rows" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="Row" maxOccurs="unbounded">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="From" type="xs:string" use="required"/>
<xs:attribute name="Thru" type="xs:string" use="required"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Values" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="Value" type="xs:string" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="Type" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="Single"/>
<xs:enumeration value="Schedule"/>
<xs:enumeration value="Vector"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="Name" type="xs:string" use="required"/>
<xs:attribute name="Value" type="xs:string" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:schema>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
