Hi, I need to perform compare (dbms_lob.compare) operation on CLOB column. I saw this post: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=1574&HighLight=1 The solution is to create LIKE predicate class and override ToQueryText() method so it will use dmbs_lob.compare(). This post is from 19-Oct-2004. Before starting to write my own LIKE predicate class I wanted to check maybe today there is some other way to compare CLOB data type?

Thank you!

Version: 2.6 Build: 2.0.3496.28931

Before starting to write my own LIKE predicate class I wanted to check maybe today there is some other way to compare CLOB data type?

Nothing new about this, so you'll have to implement the predicate yourself.

... or use FieldCompareExpression, and use a DbFunctionCall expression to the db function

Thank you!

DbFunctionCall is what we need

object[] funcParams = new object[2];
funcParams[0] = TextbankFields.Text;
funcParams[1] = tb.Text;

RelationPredicateBucket predicate = new RelationPredicateBucket();

...
...
...

predicate.PredicateExpression.Add(new EntityField2("TBText", new DbFunctionCall(DBConsts.CLOB_COMPARE_FUNCTION, funcParams)) == 0);