关于出现数据库错误ORA-01461: can bind a LONG value only for insert into a LONG column
来源:互联网 发布:淘宝的观复博物馆 编辑:程序博客网 时间:2024/06/05 04:53
发生的情况是将一个图片转换完成的二进制格式存储到数据库中的blob格式时发生,发现错误应该是parameter带来的,检查错误的出现位置发现这句话是问题的根源
paramList.Add(new OracleParameter("PHOTO", dUser.PHOTO));
将其改成就可以了
OracleParameter ora = new OracleParameter("PHOTO", OracleType.Blob, dUser.PHOTO.Length);
ora.Value = dUser.PHOTO;
paramList.Add(ora);
错误的原因可能是OracleParameter字段的大小不够引起的,初始化时将大小定义为图片的大小既可
阅读全文
0 0
- 关于出现数据库错误ORA-01461: can bind a LONG value only for insert into a LONG column
- hibernate错误:ORA-01461: can bind a LONG value only for insert into a LONG column
- 关于ORA-01461: can bind a LONG value only for insert into a LONG column
- 关于ORA-01461: can bind a LONG value only for insert into a LONG column错误处理
- ORA-01461: can bind a LONG value only for insert into a LONG column
- ORA-01461: can bind a LONG value only for insert into a LONG column
- ORA-01461: can bind a LONG value only for insert into a LONG column 问题解决方案
- ORA-01461: can bind a LONG value only for insert into a LONG column
- Siebel Exception: ORA-01461: can bind a LONG value only for insert into a LONG column
- 解决 ORA-01461: can bind a LONG value only for insert into a LONG column
- ORA-01461: can bind a LONG value only for insert into a LONG column oracle
- ORA-01461: can bind a LONG value only for insert into a LONG column
- ORA-01461: can bind a LONG value only for insert into a LONG column解决办法
- ORA-01461: can bind a LONG value only for insert into a LONG column
- ORA-01461: can bind a LONG value only for insert into a LONG column
- java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
- java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
- proc中插入VARCHAR2字段报ORA-01461: can bind a LONG value only for insert into a LONG column
- iOS开发中截取相机部分画面,切割sampleBuffer(Crop sample buffer)
- 插入排序,希尔排序
- synchronized用法
- 选择排序 -- 算法小结
- 最短路径算法
- 关于出现数据库错误ORA-01461: can bind a LONG value only for insert into a LONG column
- 操作系统:CPU调度
- 1072. Gas Station (30)
- 【jzoj5347】【NOIP2017提高A组模拟9.5】【遥远的金字塔】【斜率优化动态规划】
- 关于<s:action executeResult="true">死循环
- 2017前端面试题及答案总结(一)
- 小球碰撞-获取坐标
- Boost 学习笔记--->字符串&文本处理
- zigzag-conversion