Versions:
NHibernate 1.2.0 Beta 3,
Oracle 9.2.0.5,
.Net 2.0
I have an oracle table with a CLOB column.
Trying to save data to this column gives errors. This issue is similar, if not the same, as report on JIRA:
http://jira.nhibernate.org/browse/NH-465
Anyways. I believe I have found the problem. I created a separate debugging project that just uses ADO.NET and Oracle (no nHibernate), the oracle parameter that gets created for the CLOB column is `OracleType.VarChar`. The insert works when using that type.
However, when nHibernate creates the parameter, it uses `OracleType.NVarChar`. This I believe is what is causing the problem. If in my debugging project I change the type to `OracleType.NVarChar`, then it too will throw the Oracle exception.
Sooooo, I think I found the problem.
But I'm not quite to a solution. I'm digging into nHibernate to find out where the OracleType is derived. It seems as if it is "automatic" and it isn't specifcally set anywhere.
Does anyone have any pointers on where the command parameters are created and if I can somehow create either a UserType or a new Dialect to force using VarChar instead of NVarChar.
My oracle database does not need any non-english text so I believe it does not need NVarChar.
Thanks for any help...
Brian