I believe the problem is the use of UNION instead of UNION ALL. The UNION operator will combine the two sets and eliminate duplicates. Since CLOB types cannot be compared, the duplicate elimination part is not possible.
Using UNION ALL won’t attempt to do duplicate elimination (you probably don’t have duplicates anyways) so it should work.