Unable to Compare Two CLOBs in Oracle

If you are using Oracle and ask IBM® Cognos® Analytics to compare two CLOBs, such as where C2 is equal to C3 (C2 = C3), you will see an Oracle runtime error.

To avoid this problem, use the DBMS_LOB.compare method:

where 0 = dmbs_lob.compare (c1, c2)