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

Question

When I want to commit transaction, I get this error:

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

I save multiple entity in this transaction- How can I find where the problem is

The LONG data type has been deprecated about two decades ago, you shouldn't be using it to begin with. — a_horse_with_no_name

Rajendra Gupta Rajendra Gupta · Accepted Answer · 2019-12-02T12:02:06

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 types of columns.

**Answer**:  The LONG and LONG RAW datatypes have been deprecated and the easiest solution to the ORA-01461 error is to change the column datatype to as CLOB.

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

1 Answers