ORA-00932: inconsistent datatypes: expected - got CLOB

Try UNION ALL instead of UNION.