anbob

Large objects (LOBs) are not supported in comparison conditions. However, you can use PL/SQL programs for comparisons on CLOB data. call dbms_lob package ,If your clob  values are always less than 4k, you can simple use distinct to_char(clob) to avoid the error.