ORA-01461 错误是 Oracle 数据库中的一个常见错误,具体含义是“can bind a LONG value only for insert into a LONG column”。这个错误通常发生在尝试将一个 LONG 类型的数据绑定到一个非 LONG 类型的列,或者在不允许使用 LONG 类型数据的地方使用了 LONG 类型数据。 1. ORA-01461错误的含义 ORA-01461 错误...
',');$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++){//创建一个“空”的OCI LOB对象绑定到定位器$$this->lob[$i] = oci_new_descriptor...
今天接到开发人员报告:在用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...
INSERT ... A, B VALUES('a', 'b');也不报错。 总结: 1. 如果使用proc连接9i的库时,由于客户端和服务端的多字节字符问题,插入VARCHAR2类型时会出现ORA-01461: can bind a LONG value only for insert into a LONG column的报错。但使用PLSQL Developer或SQLPLUS这些非OCI驱动,则不会报错。 2. 使用pro...
proc中插入VARCHAR2字段报ORA-01461: can bind a LONG value only for insert into a LONG column,最近做一个天信达货运接口的项目,碰到这么个诡异的问题。背景:使用proc写的应用,向
这种情况下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...
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 ...
I seldom leave comments, however after reading a lot of responses on this page ORA-01461: can bind a LONG value only for insert into a LONG column | Observing Oracle. I actually do have 2 questions for you if you do not mind. Could it be only me or does it look li...
(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 following...
ORA-01461解决办法: 引起原因: 主要为CLOB,BLOB等大字段数据Insert引起. 我的环境: WCF + NHibernate 2.1.1 + Oracle 10g + OracleClient19g 先在下载Oracle 10g Release 2 ODAC and Oracle Developer Tools for Visual Studio .NET, 配置好数据库的链接(确保没问题,自带测试程序,可以做测试) ...