Home » Developer & Programmer » JDeveloper, Java & XML » registerschema problem
registerschema problem [message #92618] Mon, 18 October 2004 06:40
Kapil Handa
Messages: 1
Registered: October 2004
Junior Member
I am trying to use registerschema to register schema below and I am getting the error here,

15:34:45 SQL> exec dbms_xmlschema.registerSchema('http://localhost:8080/from_db.xsd', 'from_db.xsd')
;
BEGIN dbms_xmlschema.registerSchema('http://localhost:8080/from_db.xsd', 'from_db.xsd'); END;

*
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of 'f'
Error at line 1
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 3
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12
ORA-06512: at line 1

----------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xdb="http://xmlns.oracle.com/xdb">
 <xs:element name="BASKET_HEAD" schema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="TXN_KEY" xdb:SQLName="TXN_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="STORE" nillable="true" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_DATE_TIME" nillable="true" xdb:SQLName="TXN_DATE_TIME" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TRADING_DATE" xdb:SQLName="TRADING_DATE" xdb:SQLType="DATE" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TILL_BANK_ID" xdb:SQLName="TILL_BANK_ID" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="POS_NO" xdb:SQLName="POS_NO" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="POS_TXN_NO" xdb:SQLName="POS_TXN_NO" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="CASHIER_ID" xdb:SQLName="CASHIER_ID" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_VOID" default="N" xdb:SQLName="TXN_VOID" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="NO_SALE" default="N" xdb:SQLName="NO_SALE" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element ref="BASKET_ITEM" minOccurs="0" maxOccurs="unbounded"/>
    <xs:element ref="BASKET_PROM_HEAD" minOccurs="0" maxOccurs="unbounded"/>
    <xs:element ref="BASKET_STAFF_DISCOUNT" minOccurs="0" maxOccurs="unbounded"/>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="BASKET_HEAD_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TXN_KEY"/>
  </xs:key>
 </xs:element>
 <xs:element name="BASKET_ITEM" xdb:SQLName="BASKET_ITEM" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="TXN_KEY" xdb:SQLName="TXN_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_ITEM_KEY" xdb:SQLName="TXN_ITEM_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_DATE_TIME" xdb:SQLName="TXN_DATE_TIME" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="ITEM_DATE_TIME" xdb:SQLName="ITEM_DATE_TIME" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="LONG_SHORT_SALE_IND" xdb:SQLName="LONG_SHORT_SALE_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="DEPT" xdb:SQLName="DEPT" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="CLASS" xdb:SQLName="CLASS" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="SKU" default="-1" xdb:SQLName="SKU" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="UPC_EAN" default="-1" xdb:SQLName="UPC_EAN" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="CANCEL_ITEM" xdb:SQLName="CANCEL_ITEM" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="SUBTRACT_ITEM" xdb:SQLName="SUBTRACT_ITEM" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="UNKNOWN_ITEM_IND" default="N" xdb:SQLName="UNKNOWN_ITEM_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="COMP_ITEM_IND" default="N" xdb:SQLName="COMP_ITEM_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="LINKED_ITEM_IND" default="N" xdb:SQLName="LINKED_ITEM_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="GROUP_SALE_IND" default="N" xdb:SQLName="GROUP_SALE_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="DEPARTMENT_MODE" default="0" xdb:SQLName="DEPARTMENT_MODE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="EXTEND_PRICE" xdb:SQLName="EXTEND_PRICE" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="QUANTITY" xdb:SQLName="QUANTITY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="CATCHWEIGHT_QTY" xdb:SQLName="CATCHWEIGHT_QTY" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="UNIT_PRICE" xdb:SQLName="UNIT_PRICE" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="AT_FOR_QTY" xdb:SQLName="AT_FOR_QTY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PRICE_FROM_PLU" xdb:SQLName="PRICE_FROM_PLU" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="KEYED_PRICE" xdb:SQLName="KEYED_PRICE" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="SYS_REDUCTION_ID" xdb:SQLName="SYS_REDUCTION_ID" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="REDUCTION_IND" default="N" xdb:SQLName="REDUCTION_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="REFUND_IND" default="N" xdb:SQLName="REFUND_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="REFUND_REASON_CODE" xdb:SQLName="REFUND_REASON_CODE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="ITEM_ENTRY_TYPE" xdb:SQLName="ITEM_ENTRY_TYPE" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="BASKET_ITEM_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TXN_KEY"/>
   <xs:field xpath="TXN_ITEM_KEY"/>
  </xs:key>
  <xs:keyref name="BASKET_HEAD_To_BASKET_ITEM_REFBASKET_HEAD51" refer="BASKET_HEAD_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TXN_KEY"/>
  </xs:keyref>
 </xs:element>
 <xs:element name="BASKET_PROM_HEAD" xdb:SQLName="BASKET_PROM_HEAD" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="TXN_KEY" xdb:SQLName="TXN_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_PROM_KEY" xdb:SQLName="TXN_PROM_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_DATE_TIME" xdb:SQLName="TXN_DATE_TIME" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="DEPT" xdb:SQLName="DEPT" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="CLASS" xdb:SQLName="CLASS" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PROMOTION" xdb:SQLName="PROMOTION" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PROMOTION_QTY" xdb:SQLName="PROMOTION_QTY" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="CASH_POINTS_IND" xdb:SQLName="CASH_POINTS_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element ref="BASKET_PROM_ITEM" minOccurs="0" maxOccurs="unbounded"/>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="BASKET_PROM_HEAD_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TXN_KEY"/>
   <xs:field xpath="TXN_PROM_KEY"/>
  </xs:key>
  <xs:keyref name="BASKET_HEAD_To_BASKET_PROM_HEAD_REFBASKET_HEAD61" refer="BASKET_HEAD_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TXN_KEY"/>
  </xs:keyref>
  <xs:keyref name="PROMHEAD_To_BASKET_PROM_HEAD_REFPROMHEAD81" refer="PROMHEAD_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="PROMOTION"/>
  </xs:keyref>
 </xs:element>
 <xs:element name="BASKET_PROM_ITEM" xdb:SQLName="BASKET_PROM_ITEM" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="TXN_KEY" xdb:SQLName="TXN_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_PROM_KEY" xdb:SQLName="TXN_PROM_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_PROM_ITEM_KEY" xdb:SQLName="TXN_PROM_ITEM_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_DATE_TIME" xdb:SQLName="TXN_DATE_TIME" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PROMOTION" xdb:SQLName="PROMOTION" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="SKU" default="-1" xdb:SQLName="SKU" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="UPC_EAN" default="-1" xdb:SQLName="UPC_EAN" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="APPORTIONED_VAL" xdb:SQLName="APPORTIONED_VAL" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PROM_ITEM_COUNT" xdb:SQLName="PROM_ITEM_COUNT" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="BASKET_PROM_ITEM_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TXN_KEY"/>
   <xs:field xpath="TXN_PROM_KEY"/>
   <xs:field xpath="TXN_PROM_ITEM_KEY"/>
  </xs:key>
  <xs:keyref name="BASKET_PROM_HEAD_To_BASKET_PROM_ITEM_REFBASKET_PROM_HEAD91" refer="BASKET_PROM_HEAD_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TXN_KEY"/>
   <xs:field xpath="TXN_PROM_KEY"/>
  </xs:keyref>
  <xs:keyref name="PROMHEAD_To_BASKET_PROM_ITEM_REFPROMHEAD101" refer="PROMHEAD_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="PROMOTION"/>
  </xs:keyref>
 </xs:element>
 <xs:element name="BASKET_STAFF_DISCOUNT" xdb:SQLName="BASKET_STAFF_DISCOUNT" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="TXN_KEY" xdb:SQLName="TXN_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_STAFF_DISCOUNT_KEY" xdb:SQLName="TXN_STAFF_DISCOUNT_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_DATE_TIME" xdb:SQLName="TXN_DATE_TIME" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="CANCEL_ITEM" default="N" xdb:SQLName="CANCEL_ITEM" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="SUBTRACT_ITEM" default="N" xdb:SQLName="SUBTRACT_ITEM" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="ACCOUNT_NO" xdb:SQLName="ACCOUNT_NO" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="EXPIRY_DATE" xdb:SQLName="EXPIRY_DATE" xdb:SQLType="DATE" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="SALES_VALUE" xdb:SQLName="SALES_VALUE" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="ISSUE_NO" xdb:SQLName="ISSUE_NO" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="DISCOUNT_RATE" xdb:SQLName="DISCOUNT_RATE" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TENDER_VALUE" xdb:SQLName="TENDER_VALUE" xdb:SQLType="FLOAT" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:double"/>
     </xs:simpleType>
    </xs:element>
    <xs:element name="STAFF_CARD_ENTRY_IND" xdb:SQLName="STAFF_CARD_ENTRY_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="BASKET_STAFF_DISCOUNT_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TXN_KEY"/>
   <xs:field xpath="TXN_STAFF_DISCOUNT_KEY"/>
  </xs:key>
  <xs:keyref name="BASKET_HEAD_To_BASKET_STAFF_DISCOUNT_REFBASKET_HEAD171" refer="BASKET_HEAD_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TXN_KEY"/>
  </xs:keyref>
 </xs:element>
 <xs:element name="PROMHEAD" xdb:SQLName="PROMHEAD" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="PROMOTION" xdb:SQLName="PROMOTION" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element ref="BASKET_PROM_HEAD" minOccurs="0" maxOccurs="unbounded"/>
    <xs:element ref="BASKET_PROM_ITEM" minOccurs="0" maxOccurs="unbounded"/>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="PROMHEAD_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="PROMOTION"/>
  </xs:key>
 </xs:element>
 <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element ref="STORE_DAY_STATUS" minOccurs="0" maxOccurs="unbounded"/>
    <xs:element ref="STORE_POS_TXN_TIME" minOccurs="0" maxOccurs="unbounded"/>
    <xs:element ref="STORE_TIME_STATUS" minOccurs="0" maxOccurs="unbounded"/>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="STORE_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="STORE"/>
  </xs:key>
 </xs:element>
 <xs:element name="STORE_DAY_STATUS" xdb:SQLName="STORE_DAY_STATUS" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TRADING_DATE" xdb:SQLName="TRADING_DATE" xdb:SQLType="DATE" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PROCESS_KEY" xdb:SQLName="PROCESS_KEY" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="COMPLETED_IND" default="N" xdb:SQLName="COMPLETED_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="STORE_DAY_STATUS_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="STORE"/>
   <xs:field xpath="TRADING_DATE"/>
   <xs:field xpath="PROCESS_KEY"/>
  </xs:key>
  <xs:keyref name="STORE_To_STORE_DAY_STATUS_REFSTORE131" refer="STORE_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="STORE"/>
  </xs:keyref>
 </xs:element>
 <xs:element name="STORE_POS_TXN_NO_RESET" xdb:SQLName="STORE_POS_TXN_NO_RESET" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="POS_NO" xdb:SQLName="POS_NO" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="RESET_KEY" xdb:SQLName="RESET_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TXN_DATE_TIME" xdb:SQLName="TXN_DATE_TIME" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="POS_TXN_NO" xdb:SQLName="POS_TXN_NO" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PREV_POS_TXN_NO" xdb:SQLName="PREV_POS_TXN_NO" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PREV_TXN_DATE_TIME" xdb:SQLName="PREV_TXN_DATE_TIME" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="STORE_POS_TXN_NO_RESET_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="STORE"/>
   <xs:field xpath="POS_NO"/>
   <xs:field xpath="RESET_KEY"/>
  </xs:key>
  <xs:keyref name="STORE_POS_TXN_TIME_To_STORE_POS_TXN_NO_RESET_REFSTORE_POS_TXN_TIME41" refer="STORE_POS_TXN_TIME_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="STORE"/>
   <xs:field xpath="POS_NO"/>
  </xs:keyref>
 </xs:element>
 <xs:element name="STORE_POS_TXN_TIME" xdb:SQLName="STORE_POS_TXN_TIME" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="POS_NO" xdb:SQLName="POS_NO" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="LAST_POS_TXN_NO" xdb:SQLName="LAST_POS_TXN_NO" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="LAST_TXN_DATE_TIME" xdb:SQLName="LAST_TXN_DATE_TIME" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element ref="STORE_POS_TXN_NO_RESET" minOccurs="0" maxOccurs="unbounded"/>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="STORE_POS_TXN_TIME_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="STORE"/>
   <xs:field xpath="POS_NO"/>
  </xs:key>
  <xs:keyref name="STORE_To_STORE_POS_TXN_TIME_REFSTORE31" refer="STORE_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="STORE"/>
  </xs:keyref>
 </xs:element>
 <xs:element name="STORE_TIME_STATUS" xdb:SQLName="STORE_TIME_STATUS" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="STORE" xdb:SQLName="STORE" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="TIME_PERIOD_KEY" xdb:SQLName="TIME_PERIOD_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PROCESS_KEY" xdb:SQLName="PROCESS_KEY" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="COMPLETED_IND" default="N" xdb:SQLName="COMPLETED_IND" xdb:SQLType="VARCHAR2" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:string">
       <xs:maxLength value="1"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="STORE_TIME_STATUS_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="STORE"/>
   <xs:field xpath="TIME_PERIOD_KEY"/>
   <xs:field xpath="PROCESS_KEY"/>
  </xs:key>
  <xs:keyref name="STORE_To_STORE_TIME_STATUS_REFSTORE111" refer="STORE_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="STORE"/>
  </xs:keyref>
  <xs:keyref name="TIME_PERIOD_LOOKUP_To_STORE_TIME_STATUS_REFTIME_PERIOD_LOOKUP121" refer="TIME_PERIOD_LOOKUP_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TIME_PERIOD_KEY"/>
  </xs:keyref>
 </xs:element>
 <xs:element name="TIME_PERIOD_LOOKUP" xdb:SQLName="TIME_PERIOD_LOOKUP" xdb:SQLSchema="KAPIL">
  <xs:complexType>
   <xs:sequence>
    <xs:element name="TIME_PERIOD_KEY" xdb:SQLName="TIME_PERIOD_KEY" xdb:SQLType="NUMBER" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:decimal">
       <xs:totalDigits value="38"/>
       <xs:fractionDigits value="0"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PERIOD_START" xdb:SQLName="PERIOD_START" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element name="PERIOD_END" xdb:SQLName="PERIOD_END" xdb:SQLType="TIMESTAMP" xdb:SQLSchema="KAPIL">
     <xs:simpleType>
      <xs:restriction base="xs:dateTime">
       <xs:pattern value="p{Nd}{4}-p{Nd}{2}-p{Nd}{2}Tp{Nd}{2}:p{Nd}{2}:p{Nd}{2}.p{Nd}{6}"/>
      </xs:restriction>
     </xs:simpleType>
    </xs:element>
    <xs:element ref="STORE_TIME_STATUS" minOccurs="0" maxOccurs="unbounded"/>
   </xs:sequence>
  </xs:complexType>
  <xs:key name="TIME_PERIOD_LOOKUP_PrimaryKey_0">
   <xs:selector xpath="."/>
   <xs:field xpath="TIME_PERIOD_KEY"/>
  </xs:key>
 </xs:element>
</xs:schema>

Report message to a moderator

Previous Topic: Binding Column name and Values together using JDBC
Next Topic: Java or .Net
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 21:49:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.