XMLTable - 4,000 character limitation?
858642Apr 10 2012 — edited Apr 20 2012Hi all,
I have an XML file which I import into an XMLType column. I then parse one of the nodes with XMLTable. The issue I'm having is some of the records contain over 4,000 characters in one of the fields but the return is capped at 4,000. I specify the field as a CLOB in XMLTable (ex. TestField CLOB PATH 'TestField') but the data is still truncated at 4,000. I'm wondering if I'm missing something in order to allow XMLTable to return more than 4,000 characters. Please let me know if you require additional information.