ORA-31061/ORA-19202/ ORA-31111 Error While Inserting Data Into XMLTYPE Datatype

(Doc ID 2140397.1)

Last updated on AUGUST 30, 2017

Applies to:

Oracle Data Provider for .NET - Version 12.1.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

*** Checked for relevance on 30-Aug-2017 ***

Symptoms

Insert operation fails using Managed ODP.NET 12.1.0.2  while inserting data into XMLTYPE datatype column, if the length of the XML document (tags and data) is 238 or more characters.

Error Message when inserted is as below:

 

Changes

 Upgraded the ODAC/Oracle client to 12.1.0.2 Release 4

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