问题描述
当我尝试查询对象时，最终出现以下错误:
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 值-查询时发生的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！