My Oracle Support Banner

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 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

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


Insert operation fails using Managed ODP.NET  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:



 Upgraded the ODAC/Oracle client to Release 4


To view full details, 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 a vibrant support community of peers and Oracle experts.