I was trying to do a query where I want to compare a blob column and nhibernate would generate this for oracle: string queryString = "select entityroot0_.ID " + " from TESTSCOTT3.ROOTTESTOBJECT entityroot0_ where entityroot0_.ARRAY1=:p0 ";
this would result in the error: inconsistent datatypes: expected - got BLOB after some digging I found that you should compare blob fields like this: string queryString = "select entityroot0_.ID " + " from TESTSCOTT3.ROOTTESTOBJECT entityroot0_ where dbms_lob.compare(entityroot0_.ARRAY1,:p0,5,1,1) = 0"; I did a manual test of this using ado.net and it worked ok but now the big question. How do I get nhiberante to use dbms_log.compare to do a blob comare rather than the '=' compare? Is there some extensibility point in nhibernate to get it to do this? thanks scott -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
