I’m currently working on an NHibernate on Oracle project and ran into the first problem with CLOBs that I’ve had in some time. I was trying to use a property that mapped to a CLOB in a Example instance for a session Criteria object. No dice. Oracle complained saying this:
System.Data.OracleClient.OracleException: ORA-00932: inconsistent datatypes: expected - got CLOB
Well, I guess sometimes you get lucky…and sometimes you just get CLOBbered.
Guess now I have to dig into the NHibernate code if I have time. All other CRUD works nice with Clobs, just Example chokes. Could just be a dialect thing.