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

Validating XML against XSD LSX-00249: invalid date or time  (ISODateTime) 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" /> 
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: on Nov 16, 2012 1:49 PM


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