Oracle中Clob类型处理解析：ORA-01461:仅可以插入LONG列的LONG值赋值

采用参数形式，参数类型写为OracleType.Clob

List<OracleParameter> Listparameters = new List<OracleParameter>();
Listparameters.Add(new OracleParameter(":userid", logs.Userid));
Listparameters.Add(new OracleParameter(":username", logs.Username));
Listparameters.Add(new OracleParameter(":ip", logs.Ip));
Listparameters.Add(new OracleParameter(":addtime", logs.Addtime));

//logs是Clob型，需要指定类型
OracleParameter Logs = new OracleParameter(":logs", OracleType.Clob);
Logs.Value = logs.logs;
Listparameters.Add(Logs);

sqlHelper.RunSQL(Sql, Listparameters.ToArray());

欢迎访问作者个人技术博客:BlackvonCode(www.blackvon.top)
作者的微信公众号和小程序