Sunday, September 2, 2012

XMLSERIALIZE returns value truncated to 2000/4000 char

Seems like using XMLSERIALIZE or getClobVal on a XMLTYPE column stored as BINARY XML returns value truncated to 2000/4000 char without any error.
Seems like the only way to retrieve the data is to retrieve XMLTYPE using JDBC getObject which returns oracle.xdb.XMLType.
It is good in its way. It forces people to use more effective way of XML retrieval.

No comments:

Post a Comment