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删除主键约束后无法删除唯一约束索引问题的模拟与分析