ORA-31011 ORA-19202 LPX-00007 When inserting with Timestamp and supplemental logging enabled (Doc ID 2237462.1)

Last updated on FEBRUARY 24, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On a 12.1.0.2 database, getting the following errors when inserting into a table with column that has type using timestamp with time zone:

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered

Test case illustrating the issue:

SQL> create type enqueue_test_type2 as object (id number,tstmp timestamp with time zone)
2 /

SQL> create table t2 (id number , type enqueue_test_type2)
2 /

Table created.

SQL> insert into t2 values(1, enqueue_test_type2(1,to_timestamp_tz('16-JAN-2017 09:00:00.000 AMERICA/CHICAGO','DD-MON-YYYY HH24:MI:SS.FF3 TZR')))
2 /
insert into t2 values(1, enqueue_test_type2(1,to_timestamp_tz('16-JAN-2017 09:00:00.000 AMERICA/CHICAGO','DD-MON-YYYY HH24:MI:SS.FF3 TZR')))
*
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms