ORA-01461: 只能为插入到 LONG 列而绑定 LONG 值-查询时发生

问题描述

当我尝试查询对象时，最终出现以下错误:

When I try to query objects, I end up with following error:

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

有人可以帮助我了解问题的原因和解决方案吗?

Could someone please help me on the cause and solution of the problem?

推荐答案

好吧，既然你没有展示任何代码，我会在这里做一些假设.

Ok, well, since you didn't show any code, I'll make a few assumptions here.

基于 ORA-1461 错误，您似乎在 select 语句中指定了 LONG 数据类型?你想把它绑定到一个输出变量?那正确吗?该错误非常直接.您只能绑定一个 LONG 值以插入 LONG 列.

Based on the ORA-1461 error, it seems that you've specified a LONG datatype in a select statement? And you're trying to bind it to an output variable? Is that right? The error is pretty straight forward. You can only bind a LONG value for insert into LONG column.

不知道还能说什么.该错误是不言自明的.

Not sure what else to say. The error is fairly self-explanatory.

一般来说，从 LONG 数据类型转移到 CLOB 是个好主意.CLOB 得到了更好的支持，而 LONG 数据类型实际上只是为了向后兼容.

In general, it's a good idea to move away from LONG datatype to a CLOB. CLOBs are much better supported, and LONG datatypes really are only there for backward compatibility.

这是一个LONG 数据类型限制列表

希望有所帮助.

这篇关于ORA-01461: 只能为插入到 LONG 列而绑定 LONG 值-查询时发生的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！