2 Replies Latest reply: Nov 16, 2012 6:48 AM by PeterValencic RSS

    Validating XML against XSD LSX-00249: invalid date or time  (ISODateTime)

    PeterValencic
      Hello again..
      After problems with my schema validation I have new one...
      Now the problem is with ISODateTime....

      Here is some code from XSD:
      The problem in phase of validation with "CreDtTm"...
      - <xs:complexType name="GroupHeader39">
      - <xs:sequence>
        <xs:element name="MsgId" type="Max35Text" /> 
        <xs:element name="CreDtTm" type="ISODateTime" /> 
        <xs:element name="Authstn" type="Authorisation1Choice" minOccurs="0" maxOccurs="2" /> 
        <xs:element name="NbOfTxs" type="Max15NumericText" /> 
        <xs:element name="CtrlSum" type="DecimalNumber" minOccurs="0" /> 
        <xs:element name="InitgPty" type="PartyIdentification32" /> 
        <xs:element name="FwdgAgt" type="BranchAndFinancialInstitutionIdentification4" minOccurs="0" /> 
        </xs:sequence>
        </xs:complexType>
      Here is my pice of XML
      <GrpHdr>
               <MsgId>400340878</MsgId>
               <CreDtTm>2012-11-15T11:06:44</CreDtTm>
               <NbOfTxs>201</NbOfTxs>
               <CtrlSum>5790.82</CtrlSum>
      after validation I get this error:

      ORA-31154: invalid XML document
      ORA-19202: Error occurred in XML processing
      LSX-00249: invalid date or time "2012-11-15T11:06:44,000000"


      Database:
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production


      thank you for any help

      Edited by: peterv6i.blogspot.com on Nov 16, 2012 1:49 PM