I noticed this is also an issue with clob fields which is more of an issue since you can use a clob field to store really large text inforation and you can only do a compare using the dbms_lob package. Is there no other way to query a clob field other than doing a raw query?
On Jun 2, 8:24 am, srf <scott.fl...@cmgl.ca> wrote: > 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 nhusers@googlegroups.com. To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.