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

The Solution to ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying is


It can also happen with varchar2 columns. This is pretty reproducible with PreparedStatements through JDBC by simply

  1. creating a table with a column of varchar2 (20 or any arbitrary length) and
  2. inserting into the above table with a row containing more than 20 characters

So as above said it can be wrong with types, or column width exceeded.

Also note that as varchar2 allows 4k chars max, the real limit will be 2k for double byte chars

Hope this helps

~ Answered on 2013-01-24 09:24:43


Most Viewed Questions: