How to fix the Oracle error ORA-31196: XML nodes over string in size cannot be printed?

In this post, you’ll learn more about the Oracle ErrorORA-31196: XML nodes over string in size cannot be printed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31196: XML nodes over string in size cannot be printed

Reason for the Error ORA-31196: XML nodes over string in size cannot be printed

An attempt was made to use an XML Text Node with a size greater than 64K, or an XML Comment Node with a size greater than 4K. These cannot be printed. For example, trying to add children to an attribute node, or passing in a document node as a child, are unsupported operations.

How to fix the Error ORA-31196: XML nodes over string in size cannot be printed ?

You can fix this error in Oracle by following the below steps

Use getClobVal() or getStringVal() to print the Document.