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

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

      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" /> 
      Here is my pice of XML
      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"

      Oracle Database 11g Enterprise Edition Release - 64bit Production

      thank you for any help

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