Current limitations for BLOB support are as follows:
CLOB data columns cannot be part of an index.
CLOB data columns cannot be used for variables or as parameters in stored procedures.
Comparison operations are not supported on CLOB columns. Comparison operations between CLOB columns are not supported. Comparison operations between CLOB columns and columns of other data types are not supported.
The LIKE predicate is supported for CLOB columns.
Conversion, aggregate, and scalar functions are disallowed on this data type.