Handling more than 4000 characters in XMLType columns in Oracle

TOAD will allow only 4000 characters if you insert XML document as string.

Inserting XML document to XMLType column

Resolution: Use PL/SQL block in TOAD

declare x CLOB;
BEGIN
x:='long long... xml statement';
insert into (xmlCol) values (xmltype(x));
END;

Select Statements for XML data of more than 4000 characters :

Resolution: Use
GETCLOBVAL() instead of GETSTRINGVAL()