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!

Unable to FTP::get file from repository

526128Aug 30 2006 — edited Aug 31 2006

Using Oracle 10.2.0.1.0

Initially I was getting an occasional ORA-30937 when I FTP::put (using perl Net::FTP CPAN module) an instance, but this didn't pop up all of the times. So I investigated further by reducing my schema(s) and instance.

I noticed that the ORA error was introduced when I was unable to FTP::get the file back, after I FTP::put it to the repository. As I already said the ORA error (with FTP::put) wasn't reproducable, but getting the file back failed all the time.

Also note that everything validates just fine in XMLSpy.

Any help would be appreciated!!

##################################################
## The stuff that works is below:
##################################################

##
## Simple.xml:
##

<?xml version="1.0" encoding="UTF-8"?>

<Simple_XPOIS xmlns="POI" xmlns:xdb="http://xmlns.oracle.com/xdb" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="POI
http://ehvl091a:8080/home/Simple/xsd/SimplePOI.xsd">
<Simple>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
<VendorName>String</VendorName>
<ID>2</ID>
<Name>
<Text>String</Text>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
</Name>
<Contact>
<Street>String</Street>
<PlaceLevel2>String</PlaceLevel2>
<PlaceLevel3>String</PlaceLevel3>
<PlaceLevel4>String</PlaceLevel4>
<PlaceLevel5>String</PlaceLevel5>
<Country>AF</Country>
<Zip>
<Prefix>A</Prefix>
<Postfix>A</Postfix>
</Zip>
<HouseNr>String</HouseNr>
<Phone>0</Phone>
<Phone>0</Phone>
<Phone>0</Phone>
<Fax>0</Fax>
<Fax>0</Fax>
<Fax>0</Fax>
<Email>String</Email>
<Email>String</Email>
<Email>String</Email>
<WWW>String</WWW>
<WWW>String</WWW>
<WWW>String</WWW>
</Contact>
<Code>2</Code>
<AlertDefaults>2</AlertDefaults>
</Simple>
<Simple>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
<VendorName>String</VendorName>
<ID>2</ID>
<Name>
<Text>String</Text>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
</Name>
<Contact>
<Street>String</Street>
<PlaceLevel2>String</PlaceLevel2>
<PlaceLevel3>String</PlaceLevel3>
<PlaceLevel4>String</PlaceLevel4>
<PlaceLevel5>String</PlaceLevel5>
<Country>AF</Country>
<Zip>
<Prefix>A</Prefix>
<Postfix>A</Postfix>
</Zip>
<HouseNr>String</HouseNr>
<Phone>0</Phone>
<Phone>0</Phone>
<Phone>0</Phone>
<Fax>0</Fax>
<Fax>0</Fax>
<Fax>0</Fax>
<Email>String</Email>
<Email>String</Email>
<Email>String</Email>
<WWW>String</WWW>
<WWW>String</WWW>
<WWW>String</WWW>
</Contact>
<Code>2</Code>
<AlertDefaults>2</AlertDefaults>
</Simple>
<Simple>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
<VendorName>String</VendorName>
<ID>2</ID>
<Name>
<Text>String</Text>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
</Name>
<Contact>
<Street>String</Street>
<PlaceLevel2>String</PlaceLevel2>
<PlaceLevel3>String</PlaceLevel3>
<PlaceLevel4>String</PlaceLevel4>
<PlaceLevel5>String</PlaceLevel5>
<Country>AF</Country>
<Zip>
<Prefix>A</Prefix>
<Postfix>A</Postfix>
</Zip>
<HouseNr>String</HouseNr>
<Phone>0</Phone>
<Phone>0</Phone>
<Phone>0</Phone>
<Fax>0</Fax>
<Fax>0</Fax>
<Fax>0</Fax>
<Email>String</Email>
<Email>String</Email>
<Email>String</Email>
<WWW>String</WWW>
<WWW>String</WWW>
<WWW>String</WWW>
</Contact>
<Code>2</Code>
<AlertDefaults>2</AlertDefaults>
</Simple>
</Simple_XPOIS>

###
### SimplePOI.xsd:
###

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:POI="POI" xmlns:xdb="http://xmlns.oracle.com/xdb" targetNamespace="POI" elementFormDefault="qualified" attributeFormDefault="unqualified" xdb:storeVarrayAsTable="true">
<xs:include schemaLocation="http://ehvl091a:8080/home/Generic/xsd/POITypes.xsd"/>
<xs:element name="Simple_XPOIS" type="POI:SimplePOISType" xdb:defaultTable="SIMPLE_XPOIS">
</xs:element>
<xs:complexType name="SimplePOISType" xdb:SQLType="SIMPLEPOIS_T">
<xs:sequence>
<xs:element name="Simple" minOccurs="3" maxOccurs="unbounded">
<xs:complexType>
<xs:complexContent>
<xs:extension base="POI:POIType"/>
</xs:complexContent>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:schema>

###
### POITypes.xsd:
###

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:POI="POI" xmlns:xdb="http://xmlns.oracle.com/xdb" targetNamespace="POI" elementFormDefault="qualified" attributeFormDefault="unqualified" xdb:storeVarrayAsTable="true">
<xs:complexType name="POIType" xdb:SQLType="POI_T">
<xs:complexContent>
<xs:extension base="POI:PositionType">
<xs:sequence>
<xs:element name="VendorName" type="xs:string">
</xs:element>
<xs:element name="ID" type="xs:positiveInteger" xdb:SQLName="NAME">
</xs:element>
<xs:element name="Name" type="POI:NameType" maxOccurs="unbounded" xdb:SQLName="NAME" xdb:SQLCollType="NAME_V">
</xs:element>
<xs:element name="Contact" type="POI:ContactType" xdb:SQLName="CONTACT">
</xs:element>
<xs:element name="Code" type="xs:positiveInteger" maxOccurs="unbounded" xdb:SQLName="CODE" xdb:SQLCollType="CODE_V">
</xs:element>
<xs:element name="AlertDefaults" type="xs:positiveInteger" minOccurs="0" xdb:SQLName="ALERTDEFAULTS">
</xs:element>
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
<xs:complexType name="ContactType" block="restriction" xdb:SQLType="CONTACT_T">
<xs:complexContent>
<xs:extension base="POI:AddressType">
<xs:sequence>
<xs:element name="Phone" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="PHONE">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:pattern value="\p{N}*"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Fax" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="FAX">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:pattern value="\p{N}*"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Email" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="EMAIL">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="WWW" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="WWW">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
<xs:complexType name="AddressType" xdb:SQLType="ADDRESS_T">
<xs:sequence>
<xs:element name="Street" type="xs:string" minOccurs="0" xdb:SQLName="STREET">
</xs:element>
<xs:element name="PlaceLevel2" type="xs:string" xdb:SQLName="PLACELEVEL2">
</xs:element>
<xs:element name="PlaceLevel3" type="xs:string" minOccurs="0" xdb:SQLName="PLACELEVEL3">
</xs:element>
<xs:element name="PlaceLevel4" type="xs:string" minOccurs="0" xdb:SQLName="PLACELEVEL4">
</xs:element>
<xs:element name="PlaceLevel5" type="xs:string" minOccurs="0" xdb:SQLName="PLACELEVEL5">
</xs:element>
<xs:element name="Country" xdb:SQLName="COUNTRY">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="AF"/>
<xs:enumeration value="AL"/>
<xs:enumeration value="DZ"/>
<xs:enumeration value="AS"/>
<xs:enumeration value="AD"/>
<xs:enumeration value="AO"/>
<xs:enumeration value="AI"/>
<xs:enumeration value="AQ"/>
<xs:enumeration value="AG"/>
<xs:enumeration value="AR"/>
<xs:enumeration value="AM"/>
<xs:enumeration value="AW"/>
<xs:enumeration value="AU"/>
<xs:enumeration value="AT"/>
<xs:enumeration value="AZ"/>
<xs:enumeration value="BS"/>
<xs:enumeration value="BH"/>
<xs:enumeration value="BD"/>
<xs:enumeration value="BB"/>
<xs:enumeration value="BY"/>
<xs:enumeration value="BE"/>
<xs:enumeration value="BZ"/>
<xs:enumeration value="BJ"/>
<xs:enumeration value="BM"/>
<xs:enumeration value="BT"/>
<xs:enumeration value="BO"/>
<xs:enumeration value="BA"/>
<xs:enumeration value="BW"/>
<xs:enumeration value="BV"/>
<xs:enumeration value="BR"/>
<xs:enumeration value="IO"/>
<xs:enumeration value="BN"/>
<xs:enumeration value="BG"/>
<xs:enumeration value="BI"/>
<xs:enumeration value="KH"/>
<xs:enumeration value="CM"/>
<xs:enumeration value="CA"/>
<xs:enumeration value="CV"/>
<xs:enumeration value="KY"/>
<xs:enumeration value="CF"/>
<xs:enumeration value="TD"/>
<xs:enumeration value="CL"/>
<xs:enumeration value="CN"/>
<xs:enumeration value="CX"/>
<xs:enumeration value="CC"/>
<xs:enumeration value="CO"/>
<xs:enumeration value="KM"/>
<xs:enumeration value="CG"/>
<xs:enumeration value="CD"/>
<xs:enumeration value="CK"/>
<xs:enumeration value="CR"/>
<xs:enumeration value="CI"/>
<xs:enumeration value="HR"/>
<xs:enumeration value="CU"/>
<xs:enumeration value="CY"/>
<xs:enumeration value="CZ"/>
<xs:enumeration value="DK"/>
<xs:enumeration value="DJ"/>
<xs:enumeration value="DM"/>
<xs:enumeration value="DO"/>
<xs:enumeration value="EC"/>
<xs:enumeration value="EG"/>
<xs:enumeration value="SV"/>
<xs:enumeration value="GQ"/>
<xs:enumeration value="ER"/>
<xs:enumeration value="EE"/>
<xs:enumeration value="ET"/>
<xs:enumeration value="FK"/>
<xs:enumeration value="FO"/>
<xs:enumeration value="FJ"/>
<xs:enumeration value="FI"/>
<xs:enumeration value="FR"/>
<xs:enumeration value="GF"/>
<xs:enumeration value="PF"/>
<xs:enumeration value="TF"/>
<xs:enumeration value="GA"/>
<xs:enumeration value="GM"/>
<xs:enumeration value="GE"/>
<xs:enumeration value="DE"/>
<xs:enumeration value="GH"/>
<xs:enumeration value="GI"/>
<xs:enumeration value="GR"/>
<xs:enumeration value="GL"/>
<xs:enumeration value="GD"/>
<xs:enumeration value="GP"/>
<xs:enumeration value="GU"/>
<xs:enumeration value="GT"/>
<xs:enumeration value="GG"/>
<xs:enumeration value="GN"/>
<xs:enumeration value="GW"/>
<xs:enumeration value="GY"/>
<xs:enumeration value="HT"/>
<xs:enumeration value="HM"/>
<xs:enumeration value="HN"/>
<xs:enumeration value="HK"/>
<xs:enumeration value="HU"/>
<xs:enumeration value="IS"/>
<xs:enumeration value="IN"/>
<xs:enumeration value="ID"/>
<xs:enumeration value="IR"/>
<xs:enumeration value="IQ"/>
<xs:enumeration value="IE"/>
<xs:enumeration value="IM"/>
<xs:enumeration value="IL"/>
<xs:enumeration value="IT"/>
<xs:enumeration value="JM"/>
<xs:enumeration value="JP"/>
<xs:enumeration value="JE"/>
<xs:enumeration value="JO"/>
<xs:enumeration value="KZ"/>
<xs:enumeration value="KE"/>
<xs:enumeration value="KI"/>
<xs:enumeration value="KP"/>
<xs:enumeration value="KR"/>
<xs:enumeration value="KW"/>
<xs:enumeration value="KG"/>
<xs:enumeration value="LA"/>
<xs:enumeration value="LV"/>
<xs:enumeration value="LB"/>
<xs:enumeration value="LS"/>
<xs:enumeration value="LR"/>
<xs:enumeration value="LY"/>
<xs:enumeration value="LI"/>
<xs:enumeration value="LT"/>
<xs:enumeration value="LU"/>
<xs:enumeration value="MO"/>
<xs:enumeration value="MK"/>
<xs:enumeration value="MG"/>
<xs:enumeration value="MW"/>
<xs:enumeration value="MY"/>
<xs:enumeration value="MV"/>
<xs:enumeration value="ML"/>
<xs:enumeration value="MT"/>
<xs:enumeration value="MH"/>
<xs:enumeration value="MQ"/>
<xs:enumeration value="MR"/>
<xs:enumeration value="MU"/>
<xs:enumeration value="YT"/>
<xs:enumeration value="MX"/>
<xs:enumeration value="FM"/>
<xs:enumeration value="MD"/>
<xs:enumeration value="MC"/>
<xs:enumeration value="MN"/>
<xs:enumeration value="MS"/>
<xs:enumeration value="MA"/>
<xs:enumeration value="MZ"/>
<xs:enumeration value="MM"/>
<xs:enumeration value="NA"/>
<xs:enumeration value="NR"/>
<xs:enumeration value="NP"/>
<xs:enumeration value="NL"/>
<xs:enumeration value="AN"/>
<xs:enumeration value="NC"/>
<xs:enumeration value="NZ"/>
<xs:enumeration value="NI"/>
<xs:enumeration value="NE"/>
<xs:enumeration value="NG"/>
<xs:enumeration value="NU"/>
<xs:enumeration value="NF"/>
<xs:enumeration value="MP"/>
<xs:enumeration value="NO"/>
<xs:enumeration value="OM"/>
<xs:enumeration value="PK"/>
<xs:enumeration value="PW"/>
<xs:enumeration value="PS"/>
<xs:enumeration value="PA"/>
<xs:enumeration value="PG"/>
<xs:enumeration value="PY"/>
<xs:enumeration value="PE"/>
<xs:enumeration value="PH"/>
<xs:enumeration value="PN"/>
<xs:enumeration value="PL"/>
<xs:enumeration value="PT"/>
<xs:enumeration value="PR"/>
<xs:enumeration value="QA"/>
<xs:enumeration value="RE"/>
<xs:enumeration value="RO"/>
<xs:enumeration value="RU"/>
<xs:enumeration value="RW"/>
<xs:enumeration value="WS"/>
<xs:enumeration value="SM"/>
<xs:enumeration value="ST"/>
<xs:enumeration value="SA"/>
<xs:enumeration value="SN"/>
<xs:enumeration value="YU"/>
<xs:enumeration value="SC"/>
<xs:enumeration value="SL"/>
<xs:enumeration value="SG"/>
<xs:enumeration value="SK"/>
<xs:enumeration value="SI"/>
<xs:enumeration value="SB"/>
<xs:enumeration value="SO"/>
<xs:enumeration value="ZA"/>
<xs:enumeration value="GS"/>
<xs:enumeration value="ES"/>
<xs:enumeration value="LK"/>
<xs:enumeration value="SH"/>
<xs:enumeration value="KN"/>
<xs:enumeration value="LC"/>
<xs:enumeration value="PM"/>
<xs:enumeration value="VC"/>
<xs:enumeration value="SD"/>
<xs:enumeration value="SR"/>
<xs:enumeration value="SJ"/>
<xs:enumeration value="SZ"/>
<xs:enumeration value="CE"/>
<xs:enumeration value="CH"/>
<xs:enumeration value="SY"/>
<xs:enumeration value="TW"/>
<xs:enumeration value="TJ"/>
<xs:enumeration value="TZ"/>
<xs:enumeration value="TH"/>
<xs:enumeration value="TL"/>
<xs:enumeration value="TG"/>
<xs:enumeration value="TK"/>
<xs:enumeration value="TO"/>
<xs:enumeration value="TT"/>
<xs:enumeration value="TN"/>
<xs:enumeration value="TR"/>
<xs:enumeration value="TM"/>
<xs:enumeration value="TC"/>
<xs:enumeration value="TV"/>
<xs:enumeration value="UG"/>
<xs:enumeration value="UA"/>
<xs:enumeration value="AG"/>
<xs:enumeration value="GB"/>
<xs:enumeration value="US"/>
<xs:enumeration value="UM"/>
<xs:enumeration value="UY"/>
<xs:enumeration value="UZ"/>
<xs:enumeration value="VU"/>
<xs:enumeration value="VA"/>
<xs:enumeration value="VE"/>
<xs:enumeration value="VN"/>
<xs:enumeration value="VG"/>
<xs:enumeration value="VI"/>
<xs:enumeration value="WF"/>
<xs:enumeration value="EH"/>
<xs:enumeration value="YE"/>
<xs:enumeration value="YU"/>
<xs:enumeration value="ZM"/>
<xs:enumeration value="ZW"/>
<xs:enumeration value="CS"/>
<xs:enumeration value="DD"/>
<xs:enumeration value="PC"/>
<xs:enumeration value="SU"/>
<xs:enumeration value="SE"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Zip" block="restriction" minOccurs="0" xdb:SQLName="ZIP">
<xs:complexType>
<xs:sequence>
<xs:element name="Prefix" xdb:SQLName="PREFIX">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
<xs:pattern value="[A-Za-z0-9]*"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Postfix" minOccurs="0" xdb:SQLName="POSTFIX">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
<xs:pattern value="[A-Za-z0-9]*"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="HouseNr" type="xs:string" block="restriction" minOccurs="0" xdb:SQLName="HOUSENR">
</xs:element>
</xs:sequence>
</xs:complexType>
<xs:complexType name="PositionType" xdb:SQLType="POSITION_T">
<xs:sequence>
<xs:element name="Longitude" type="xs:string" block="#all" xdb:SQLName="LONGITUDE">
</xs:element>
<xs:element name="Latitude" type="xs:string" block="#all" xdb:SQLName="LATITUDE">
</xs:element>
<xs:element name="Altitude" type="xs:string" minOccurs="0" xdb:SQLName="ALTITUDE">
</xs:element>
</xs:sequence>
</xs:complexType>
<xs:complexType name="AlertInfoType" xdb:SQLType="ALERTINFO_T">
<xs:sequence>
<xs:element name="AZ_TYPE" minOccurs="0" xdb:SQLName="AZ_TYPE">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="C"/>
<xs:enumeration value="R"/>
<xs:enumeration value="P"/>
<xs:enumeration value="O"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="RADAR_ALERT_TYPE" minOccurs="0" xdb:SQLName="RADAR_ALERT_TYPE">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="0"/>
<xs:enumeration value="1"/>
<xs:enumeration value="2"/>
<xs:enumeration value="3"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="SPEED_LIMIT" type="xs:positiveInteger" minOccurs="0" xdb:SQLName="SPEED_LIMIT"/>
<xs:element name="AZ_OR" minOccurs="0" xdb:SQLName="AZ_OR">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ALERT_ICON" type="xs:IDREF" minOccurs="0" xdb:SQLName="ALERT_ICON">
</xs:element>
<xs:element name="DEF_SPEED_UNIT" minOccurs="0" xdb:SQLName="DEF_SPEED_UNIT">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="M"/>
<xs:enumeration value="KM"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="MAX_AZ_DISTANCE" type="xs:positiveInteger" minOccurs="0" xdb:SQLName="MAX_AZ_DISTANCE"/>
<xs:element name="DEF_ACTIVATION_TIME" type="xs:positiveInteger" minOccurs="0" xdb:SQLName="DEF_ACTIVATION_TIME"/>
<xs:element name="DEF_AZ_SPEC" type="xs:positiveInteger" minOccurs="0" xdb:SQLName="DEF_AZ_SPEC"/>
<xs:element name="DEF_PROJ_DIST" type="xs:positiveInteger" minOccurs="0" xdb:SQLName="DEF_PROJ_DIST"/>
<xs:element name="DEF_AZ_TYPE" minOccurs="0" xdb:SQLName="DEF_AZ_TYPE">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="C"/>
<xs:enumeration value="R"/>
<xs:enumeration value="P"/>
<xs:enumeration value="O"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PRIORITY" type="xs:positiveInteger" minOccurs="0" xdb:SQLName="PRIORITY"/>
</xs:sequence>
</xs:complexType>
<xs:complexType name="RelationType" xdb:SQLType="RELATION_T">
<xs:sequence>
<xs:element name="Type" type="xs:positiveInteger" xdb:SQLName="TYPE">
</xs:element>
<xs:element name="AssociationType" type="xs:positiveInteger" xdb:SQLName="ASSOCIATIONTYPE">
</xs:element>
<xs:element name="WithPOI" type="xs:positiveInteger" xdb:SQLName="WITHPOI">
</xs:element>
</xs:sequence>
</xs:complexType>
<xs:complexType name="NameType" xdb:SQLType="NAME_T">
<xs:sequence>
<xs:element name="Text" xdb:SQLName="TEXT">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Synonyms" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="SYNONYMS">
<xs:complexType>
<xs:sequence>
<xs:element name="Locale" type="xs:positiveInteger" xdb:SQLName="LOCALE"/>
<xs:element name="Text" maxOccurs="unbounded" xdb:SQLName="TEXT" xdb:SQLCollType="TEXT_V">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Phonyms" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="PHONYMS">
<xs:complexType>
<xs:sequence>
<xs:element name="Locale" type="xs:positiveInteger" xdb:SQLName="LOCALE"/>
<xs:element name="Text" maxOccurs="unbounded" xdb:SQLName="TEXT">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:schema>

##################################################
## The stuff that DOESN'T works is below:
##################################################

##
## Simple.xml
##

<?xml version="1.0" encoding="UTF-8"?>

<Simple_XPOIS xmlns="POI" xmlns:xdb="http://xmlns.oracle.com/xdb" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="POI
http://ehvl091a:8080/home/Simple/xsd/SimplePOI.xsd">
<Simple>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
<VendorName>String</VendorName>
<ID>2</ID>
<Name>
<Text>String</Text>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
</Name>
<Contact>
<Street>String</Street>
<PlaceLevel2>String</PlaceLevel2>
<PlaceLevel3>String</PlaceLevel3>
<PlaceLevel4>String</PlaceLevel4>
<PlaceLevel5>String</PlaceLevel5>
<Country>AF</Country>
<Zip>
<Prefix>A</Prefix>
<Postfix>A</Postfix>
</Zip>
<HouseNr>String</HouseNr>
<Phone>0</Phone>
<Phone>0</Phone>
<Phone>0</Phone>
<Fax>0</Fax>
<Fax>0</Fax>
<Fax>0</Fax>
<Email>String</Email>
<Email>String</Email>
<Email>String</Email>
<WWW>String</WWW>
<WWW>String</WWW>
<WWW>String</WWW>
</Contact>
<Code>2</Code>
<EntryPoint>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
</EntryPoint>
<EntryPoint>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
</EntryPoint>
<EntryPoint>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
</EntryPoint>
<AlertDefaults>2</AlertDefaults>
</Simple>
<Simple>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
<VendorName>String</VendorName>
<ID>2</ID>
<Name>
<Text>String</Text>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
</Name>
<Contact>
<Street>String</Street>
<PlaceLevel2>String</PlaceLevel2>
<PlaceLevel3>String</PlaceLevel3>
<PlaceLevel4>String</PlaceLevel4>
<PlaceLevel5>String</PlaceLevel5>
<Country>AF</Country>
<Zip>
<Prefix>A</Prefix>
<Postfix>A</Postfix>
</Zip>
<HouseNr>String</HouseNr>
<Phone>0</Phone>
<Phone>0</Phone>
<Phone>0</Phone>
<Fax>0</Fax>
<Fax>0</Fax>
<Fax>0</Fax>
<Email>String</Email>
<Email>String</Email>
<Email>String</Email>
<WWW>String</WWW>
<WWW>String</WWW>
<WWW>String</WWW>
</Contact>
<Code>2</Code>
<EntryPoint>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
</EntryPoint>
<EntryPoint>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
</EntryPoint>
<EntryPoint>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
</EntryPoint>
<AlertDefaults>2</AlertDefaults>
</Simple>
<Simple>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
<VendorName>String</VendorName>
<ID>2</ID>
<Name>
<Text>String</Text>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Synonyms>
<Locale>2</Locale>
<Text>String</Text>
</Synonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
<Phonyms>
<Locale>2</Locale>
<Text>String</Text>
</Phonyms>
</Name>
<Contact>
<Street>String</Street>
<PlaceLevel2>String</PlaceLevel2>
<PlaceLevel3>String</PlaceLevel3>
<PlaceLevel4>String</PlaceLevel4>
<PlaceLevel5>String</PlaceLevel5>
<Country>AF</Country>
<Zip>
<Prefix>A</Prefix>
<Postfix>A</Postfix>
</Zip>
<HouseNr>String</HouseNr>
<Phone>0</Phone>
<Phone>0</Phone>
<Phone>0</Phone>
<Fax>0</Fax>
<Fax>0</Fax>
<Fax>0</Fax>
<Email>String</Email>
<Email>String</Email>
<Email>String</Email>
<WWW>String</WWW>
<WWW>String</WWW>
<WWW>String</WWW>
</Contact>
<Code>2</Code>
<EntryPoint>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
</EntryPoint>
<EntryPoint>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
</EntryPoint>
<EntryPoint>
<Longitude>String</Longitude>
<Latitude>String</Latitude>
<Altitude>String</Altitude>
</EntryPoint>
<AlertDefaults>2</AlertDefaults>
</Simple>
</Simple_XPOIS>

##
## SimplePOI.xsd
##

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:POI="POI" xmlns:xdb="http://xmlns.oracle.com/xdb" targetNamespace="POI" elementFormDefault="qualified" attributeFormDefault="unqualified" xdb:storeVarrayAsTable="true">
<xs:include schemaLocation="http://ehvl091a:8080/home/Generic/xsd/POITypes.xsd"/>
<xs:element name="Simple_XPOIS" type="POI:SimplePOISType" xdb:defaultTable="SIMPLE_XPOIS">
</xs:element>
<xs:complexType name="SimplePOISType" xdb:SQLType="SIMPLEPOIS_T">
<xs:sequence>
<xs:element name="Simple" minOccurs="3" maxOccurs="unbounded">
<xs:complexType>
<xs:complexContent>
<xs:extension base="POI:POIType"/>
</xs:complexContent>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:schema>

##
## POITypes.xsd
##

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:POI="POI" xmlns:xdb="http://xmlns.oracle.com/xdb" targetNamespace="POI" elementFormDefault="qualified" attributeFormDefault="unqualified" xdb:storeVarrayAsTable="true">
<xs:complexType name="POIType" xdb:SQLType="POI_T">
<xs:complexContent>
<xs:extension base="POI:PositionType">
<xs:sequence>
<xs:element name="VendorName" type="xs:string">
</xs:element>
<xs:element name="ID" type="xs:positiveInteger" xdb:SQLName="NAME">
</xs:element>
<xs:element name="Name" type="POI:NameType" maxOccurs="unbounded" xdb:SQLName="NAME" xdb:SQLCollType="NAME_V">
</xs:element>
<xs:element name="Contact" type="POI:ContactType" xdb:SQLName="CONTACT">
</xs:element>
<xs:element name="Code" type="xs:positiveInteger" maxOccurs="unbounded" xdb:SQLName="CODE" xdb:SQLCollType="CODE_V">
</xs:element>
<xs:element name="EntryPoint" type="POI:PositionType" minOccurs="0" maxOccurs="9" xdb:SQLName="ENTRYPOINT">
</xs:element>
<xs:element name="AlertDefaults" type="xs:positiveInteger" minOccurs="0" xdb:SQLName="ALERTDEFAULTS">
</xs:element>
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
<xs:complexType name="ContactType" block="restriction" xdb:SQLType="CONTACT_T">
<xs:complexContent>
<xs:extension base="POI:AddressType">
<xs:sequence>
<xs:element name="Phone" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="PHONE">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:pattern value="\p{N}*"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Fax" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="FAX">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:pattern value="\p{N}*"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Email" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="EMAIL">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="WWW" minOccurs="0" maxOccurs="unbounded" xdb:SQLName="WWW">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
<xs:complexType name="AddressType" xdb:SQLType="ADDRESS_T">
<xs:sequence>
<xs:element name="Street" type="xs:string" minOccurs="0" xdb:SQLName="STREET">
</xs:element>
<xs:element name="PlaceLevel2" type="xs:string" xdb:SQLName="PLACELEVEL2">
</xs:element>
<xs:element name="PlaceLevel3" type="xs:string" minOccurs="0" xdb:SQLName="PLACELEVEL3">
</xs:element>
<xs:element name="PlaceLevel4" type="xs:string" minOccurs="0" xdb:SQLName="PLACELEVEL4">
</xs:element>
<xs:element name="PlaceLevel5" type="xs:string" minOccurs="0" xdb:SQLName="PLACELEVEL5">
</xs:element>
<xs:element name="Country" xdb:SQLName="COUNTRY">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="AF"/>
<xs:enumeration value="AL"/>
<xs:enumeration value="DZ"/>
<xs:enumeration value="AS"/>
<xs:enumeration value="AD"/>
<xs:enumeration value="AO"/>
<xs:enumeration value="AI"/>
<xs:enumeration value="AQ"/>
<xs:enumeration value="AG"/>
<xs:enumeration value="AR"/>
<xs:enumeration value="AM"/>
<xs:enumeration value="AW"/>
<xs:enumeration value="AU"/>
<xs:enumeration value="AT"/>
<xs:enumeration value="AZ"/>
<xs:enumeration value="BS"/>
<xs:enumeration value="BH"/>
<xs:enumeration value="BD"/>
<xs:enumeration value="BB"/>
<xs:enumeration value="BY"/>
<xs:enumeration value="BE"/>
<xs:enumeration value="BZ"/>
<xs:enumeration value="BJ"/>
<xs:enumeration value="BM"/>
<xs:enumeration value="BT"/>
<xs:enumeration value="BO"/>
<xs:enumeration value="BA"/>
<xs:enumeration value="BW"/>
<xs:enumeration value="BV"/>
<xs:enumeration value="BR"/>
<xs:enumeration value="IO"/>
<xs:enumeration value="BN"/>
<xs:enumeration value="BG"/>
<xs:enumeration value="BI"/>
<xs:enumeration value="KH"/>
<xs:enumeration value="CM"/>
<xs:enumeration value="CA"/>
<xs:enumeration value="CV"/>
<xs:enumeration value="KY"/>
<xs:enumeration value="CF"/>
<xs:enumeration value="TD"/>
<xs:enumeration value="CL"/>
<xs:enumeration value="CN"/>
<xs:enumeration value="CX"/>
<xs:enumeration value="CC"/>
<xs:enumeration value="CO"/>
<xs:enumeration value="KM"/>
<xs:enumeration value="CG"/>
<xs:enumeration value="CD"/>
<xs:enumeration value="CK"/>
<xs:enumeration value="CR"/>
<xs:enumeration value="CI"/>
<xs:enumeration value="HR"/>
<xs:enumeration value="CU"/>
<xs:enumeration value="CY"/>
<xs:enumeration value="CZ"/>
<xs:enumeration value="DK"/>
<xs:enumeration value="DJ"/>
<xs:enumeration value="DM"/>
<xs:enumeration value="DO"/>
<xs:enumeration value="EC"/>
<xs:enumeration value="EG"/>
<xs:enumeration value="SV"/>
<xs:enumeration value="GQ"/>
<xs:enumeration value="ER"/>
<xs:enumeration value="EE"/>
<xs:enumeration value="ET"/>
<xs:enumeration value="FK"/>
<xs:enumeration value="FO"/>
<xs:enumeration value="FJ"/>
<xs:enumeration value="FI"/>
<xs:enumeration value="FR"/>
<xs:enumeration value="GF"/>
<xs:enumeration value="PF"/>
<xs:enumeration value="TF"/>
<xs:enumeration value="GA"/>
<xs:enumeration value="GM"/>
<xs:enumeration value="GE"/>
<xs:enumeration value="DE"/>
<xs:enumeration value="GH"/>
<xs:enumeration value="GI"/>
<xs:enumeration value="GR"/>
<xs:enumeration value="GL"/>
<xs:enumeration value="GD"/>
<xs:enumeration value="GP"/>
<xs:enumeration value="GU"/>
<xs:enumeration value="GT"/>
<xs:enumeration value="GG"/>
<xs:enumeration value="GN"/>
<xs:enumeration value="GW"/>
<xs:enumeration value="GY"/>
<xs:enumeration value="HT"/>
<xs:enumeration value="HM"/>
<xs:enumeration value="HN"/>
<xs:enumeration value="HK"/>
<xs:enumeration value="HU"/>
<xs:enumeration value="IS"/>
<xs:enumeration value="IN"/>
<xs:enumeration value="ID"/>
<xs:enumeration value="IR"/>
<xs:enumeration value="IQ"/>
<xs:enumeration value="IE"/>
<xs:enumeration value="IM"/>
<xs:enumeration value="IL"/>
<xs:enumeration value="IT"/>
<xs:enumeration value="JM"/>
<xs:enumeration value="JP"/>
<xs:enumeration value="JE"/>
<xs:enumeration value="JO"/>
<xs:enumeration value="KZ"/>
<xs:enumeration value="KE"/>
<xs:enumeration value="KI"/>
<xs:enumeration value="KP"/>
<xs:enumeration value="KR"/>
<xs:enumeration value="KW"/>
<xs:enumeration value="KG"/>
<xs:enumeration value="LA"/>
<xs:enumeration value="LV"/>
<xs:enumeration value="LB"/>
<xs:enumeration value="LS"/>
<xs:enumeration value="LR"/>
<xs:enumeration value="LY"/>
<xs:enumeration value="LI"/>
<xs:enumeration value="LT"/>
<xs:enumeration value="LU"/>
<xs:enumeration value="MO"/>
<xs:enumeration value="MK"/>
<xs:enumeration value="MG"/>
<xs:enumeration value="MW"/>
<xs:enumeration value="MY"/>
<xs:enumeration value="MV"/>
<xs:enumeration value="ML"/>
<xs:enumeration value="MT"/>
<xs:enumeration value="MH"/>
<xs:enumeration value="MQ"/>
<xs:enumeration value="MR"/>
<xs:enumeration value="MU"/>
<xs:enumeration value="YT"/>
<xs:enumeration value="MX"/>
<xs:enumeration value="FM"/>
<xs:enumeration value="MD"/>
<xs:enumeration value="MC"/>
<xs:enumeration value="MN"/>
<xs:enumeration value="MS"/>
<xs:enumeration value="MA"/>
<xs:enumeration value="MZ"/>
<xs:enumeration value="MM"/>
<xs:enumeration value="NA"/>
<xs:enumeration value="NR"/>
<xs:enumeration value="NP"/>
<xs:enumeration value="NL"/>
<xs:enumeration value="AN"/>
<xs:enumeration value="NC"/>
<xs:enumeration value="NZ"/>
<xs:enumeration value="NI"/>
<xs:enumeration value="NE"/>
<xs:enumeration value="NG"/>
<xs:enumeration value="NU"/>
<xs:enumeration value="NF"/>
<xs:enumeration value="MP"/>
<xs:enumeration value="NO"/>
<xs:enumeration value="OM"/>
<xs:enumeration value="PK"/>
<xs:enumeration value="PW"/>
<xs:enumeration value="PS"/>
<xs:enumeration value="PA"/>
<xs:enumeration value="PG"/>
<xs:enumeration value="PY"/>
<xs:enumeration value="PE"/>
<xs:enumeration value="PH"/>
<xs:enumeration value="PN"/>
<xs:enumeration value="PL"/>
<xs:enumeration value="PT"/>
<xs:enumeration value="PR"/>
<xs:enumeration value="QA"/>
<xs:enumeration value="RE"/>
<xs:enumeration value="RO"/>
<xs:enumeration value="RU"/>
<xs:enumeration value="RW"/>
<xs:enumeration value="WS"/>
<xs:enumeration value="SM"/>
<xs:enumeration value="ST"/>
<xs:enumeration value="SA"/>
<xs:enumeration value="SN"/>
<xs:enumeration value="YU"/>
<xs:enumeration value="SC"/>
<xs:enumeration value="SL"/>
<xs:enumeration value="SG"/>
<xs:enumeration value="SK"/>
<xs:enumeration value="SI"/>
<xs:enumeration value="SB"/>
<xs:enumeration value="SO"/>
<xs:enumeration value="ZA"/>
<xs:enumeration value="GS"/>
<xs:enumeration value="ES"/>
<xs:enumeration value="LK"/>
<xs:enumeration value="SH"/>
<xs:enumeration value="KN"/>
<xs:enumeration value="LC"/>
<xs:enumeration value="PM"/>
<xs:enumeration value="VC"/>
<xs:enumeration value="SD"/>
<xs:enumeration value="SR"/>
<xs:enumeration value="SJ"/>
<xs:enumeration value="SZ"/>
<xs:enumeration value="CE"/>
<xs:enumeration value="CH"/>
<xs:enumeration value="SY"/>
<xs:enumeration value="TW"/>
<xs:enumeration value="TJ"/>
<xs:enumeration value="TZ"/>
<xs:enumeration value="TH"/>
<xs:enumeration value="TL"/>
<xs:enumeration value="TG"/>
<xs:enumeration value="TK"/>
<xs:enumeration value="TO"/>
<xs:enumeration value="TT"/>
<xs:enumeration value="TN"/>
<xs:enumeration value="TR"/>
<xs:enumeration value="TM"/>
<xs:enumeration value="TC"/>
<xs:enumeration value="TV"/>
<xs:enumeration value="UG"/>
<xs:enumeration value="UA"/>
<xs:enumeration value="AG"/>
<xs:enumeration value="GB"/>
<xs:enumeration value="US"/>
<xs:enumeration value=&qu

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2006

Added on Aug 30 2006

#performance-availability, #xml-db

3 comments

802 views