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

Posted on Edited on In Views: Disqus: Symbols count in article: 319 Reading time ≈ 1 mins.

Intro 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.

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

1
2
3
4
在執行update sql at oracle時，出現ORA-01461: can bind a LONG value only
for insert into a LONG column錯誤訊息。
經查發現是有個欄位的值超過VARCHAR2(4000)導致，
解決方法是增加該欄位length是否超過欄位長度上限檢核。