This discussion is archived
2 Replies Latest reply: Nov 16, 2012 4:48 AM by peterv6i.blogspot.com RSS

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

peterv6i.blogspot.com Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points