> http://thebasilet.blogspot.com/2009/07/nhibernate-oracle-clobs.html
> ...
> In reality this is a bug with the microsoft oracle client driver.

using System.Data.OracleClient;
...
//tmpString = new string('я', 2000);
//tmpString = new string('я', 2001);
//tmpString = new string('я', 3000);
//tmpString = new string('я', 3999);
//tmpString = new string('я', 4000);
//tmpString = new string('я', 4001);
//tmpString = new string('я', 0x0ffff);

cmd.CommandType = CommandType.Text;
cmd.CommandText = "update TestTableTypes set FClob = :FClob, FNClob
= :FNClob";
cmd.Parameters.Add(":FClob", OracleType.Clob).Value = tmpString;
cmd.Parameters.Add(":FNClob", OracleType.NClob).Value = tmpString;
tmpInt=cmd.ExecuteNonQuery();

works fine.

-- 
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.

Reply via email to