XML validation failing after Oracle upgrade
Hello ,
We have recently upgraded our Oracle database to version 19c and since the upgrade existing functionality of inserting XML files into a XMLTYPE column is failing. This column is validated against a XMLSCHEMA file (xsd).
Oracle full Version name : "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0"
The error details are as below.
INSERT INTO xxx_test (filename,XMLTYPE_Column) Values
('file_name.xml',XMLType(bfilename('Oracle_dir','file_name.xml'),nls_charset_id('AL32UTF8')));
Error report -
ORA-30992: error occurred at Xpath /list/header/thisUpdate
ORA-01830: date format picture ends before converting entire input string
We were able to load this XML file before but now its throwing this error.