ORA-01461 错误是 Oracle 数据库中的一个常见错误,具体含义是“can bind a LONG value only for insert into a LONG column”。这个错误通常发生在尝试将一个 LONG 类型的数据绑定到一个非 LONG 类型的列,或者在不允许使用 LONG 类型数据的地方使用了 LONG 类型数据。 1. ORA-01461错误的含义 ORA-01461 错误...
}$returning_str.=" RETURNING ".join(',',$this->lob)." INTO ".rtrim($lob_str,',');$where_str=strtoupper($this->where);//组装SQL$sql= "UPDATE$this->table SET$set_strWHERE$where_str".$returning_str;$stmt= oci_parse($this->conn,$sql);for($i=0;$i<count($this->lob);$i++...
今天接到开发人员报告:在用jdbc导入数据时遇到ORA-01461 ORA-01461 can bind a LONG value only for insert into a LONG column Cause: An attempt was made to insert a value from a LONG datatype into another datatype. This is not allowed. Action: Do not try to insert LONG datatypes into other...
ORA-01461: can bind a LONG value only for insert into a LONG column Cause Sign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle Support account? Click to get started! In this Document Symptoms Cause Solution My Oracle Support ...
proc中插入VARCHAR2字段报ORA-01461: can bind a LONG value only for insert into a LONG column,最近做一个天信达货运接口的项目,碰到这么个诡异的问题。背景:使用proc写的应用,向
Error: ORA-01461: can bind a LONG value only for insert into a LONG column What bind value or changes I have to do, to make it work? oracledb 6.0.0 app.txt jashanbaatthadded thebuglabelJun 22, 2023 Member Member sharadrajucommentedJun 22, 2023• ...
(ORA-01461: can bind a LONG value only for insert into a LONG column) or com.opensymphony.module.propertyset.PropertyImplementationException: while updating: [GenericEntity:OSPropertyText][value, ...] (SQL Exception while executing the followi...
这种情况下oracle会把data_length长度超过4000的当做LONG型处理,你的表中有两个这样的字段,插入数据时相当于同时操作2个LONG字段,所以报错。 建议减小字段长度或拆分 案例2: 今天接到开发人员报告:在用jdbc导入数据时遇到ORA-01461 ORA-01461 can bind a LONG value only for insert into a LONG column...
This part of code has a bad behaviour on ORACLE DB. mybatis-3/src/main/java/org/apache/ibatis/type/ClobTypeHandler.java Lines 30 to 35 in 519cf8e @Override public void setNonNullParameter(PreparedStatement ps, int i, String parameter, Jd...
引起原因: 主要为CLOB,BLOB等大字段数据Insert引起. 我的环境: WCF + NHibernate 2.1.1 + Oracle 10g + OracleClient19g 先在下载Oracle 10g Release 2 ODAC and Oracle Developer Tools for Visual Studio .NET, 配置好数据库的链接(确保没问题,自带测试程序,可以做测试) ...