CLOBbered again!

Hey all,

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. 


How to enlist ADO commands into an NHibernate transaction