XML Database (MOSC)

MOSC Banner

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center