xmltype.schemavalidate fails sporadically with the error LSX-00023: unknown namespace URI " "
Hello,every day we load XML-Data to our Database (11.1.0.7) via XDB.
Sporadically (2 times in the last 2 months) the xmltype.schemavalidate fails with the following error:ORA-31154: invalid XML document
ORA-19202: Error
occurred in XML processing
LSX-00023: unknown namespace URI " ":It is a very strange situation, because if we restarts the job (loading data from XDB) next day the job works fine without any error.
The inputfiles and the code is the same as before.It is a very simple XML, without any namespace definition:"<?xml version="1.0" encoding="ISO-8859-1"?>
<ctlDatei>
<Beleg>
<ArchivIndex>1133330005601</ArchivIndex>
<Status>OK</Status>
</Beleg>
<Beleg>
<ArchivIndex>1133330007995</ArchivIndex>
Sporadically (2 times in the last 2 months) the xmltype.schemavalidate fails with the following error:ORA-31154: invalid XML document
ORA-19202: Error
occurred in XML processing
LSX-00023: unknown namespace URI " ":It is a very strange situation, because if we restarts the job (loading data from XDB) next day the job works fine without any error.
The inputfiles and the code is the same as before.It is a very simple XML, without any namespace definition:"<?xml version="1.0" encoding="ISO-8859-1"?>
<ctlDatei>
<Beleg>
<ArchivIndex>1133330005601</ArchivIndex>
<Status>OK</Status>
</Beleg>
<Beleg>
<ArchivIndex>1133330007995</ArchivIndex>
0