您好,欢迎访问一九零五行业门户网

ORA-01461: can bind a LONG value only for insert into a LONG

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错误处理
[日期:2013-03-30]来源:linux社区 作者:linux[字体:]
异常:ora-01461: can bind a long value only for insert into a long column
出错原因:当对oracle数据库在clob类型字段插入值str,当str字符长度大于4000 就抛出如上异常
解决方法:查看项目中的驱动,和数据库的驱动是否一样, 把驱动替换成相同版本的异常出来,插入大容量数据正常!
查看ojdbc 版本信息 
manifest-version: 1.0
 specification-title:    oracle jdbc driver classes for use with jdk14
 sealed: true
 created-by: 1.4.2_14 (sun microsystems inc.)
 implementation-title:  ojdbc14.jar
 specification-vendor:  oracle corporation
 specification-version:  oracle jdbc driver version - 10.2.0.4.0
 implementation-version: oracle jdbc driver version - 10.2.0.4.0
 implementation-vendor:  oracle corporation
 implementation-time:    sat feb  2 11:40:29 2008
name: oracle/sql/converter/
 sealed: false
name: oracle/sql/
 sealed: false
name: oracle/sql/converter_xcharset/
 sealed: false
0
oracle之报错:ora-00054: 资源正忙,,要求指定 nowait
oracle 10g删除主键约束后无法删除唯一约束索引问题的模拟与分析
其它类似信息

推荐信息