I experience something strange to me and I am open to any commentary helping me to solve my problem.
I am using dbms_xmldom to create xml file in PL/SQL.
Let's say I have created such a document named "doc" with this. I write it down to a file with this :
dbms_xmldom.writeToFile(doc,'docFile', 'UTF-8');
v_xml:=DBMS_XMLDOM.GETXMLTYPE(doc);
dbms_xmldom.freeDocument(doc);
I would like to validate this document. Here we go :
v_schema:=v_xml.createSchemaBasedXML('myValidationFile.xsd');
v_schema.schemavalidate();
Here I have this error :
ORA-31154: invalid XML document
ORA-19202: Error occurred in XML processing
LSX-00249: invalid date or time "2015-01-07T15:20:41,000000"
Looking at my file called 'docFile' I just see 2015-01-07T15:20:41. I dont know where this ',000000' comes from.
This has always worked before but I am testing a platform with Oracle 11 now (before it was Oracle 10). I dont know if this has something to do with it but I am telling anyway.
Thanks for the suggestions
No comments:
Post a Comment