本文主要是介绍php+ora01461,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删除主键约束后无法删除唯一约束索引问题的模拟与分析
本文原创发布php中文网,转载请注明出处,感谢您的尊重!
这篇关于php+ora01461,ORA-01461: can bind a LONG value only for insert into a LONG的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!