I got “ORA-01461: can bind a LONG value only for insert into a LONG column ” error in Oracle database.
ORA-01461: can bind a LONG value only for insert into a LONG column
Details of error are as follows.
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.
can bind a LONG value only for insert into a LONG column
This ORA-01461 errors are related with the attempt was made to insert a value from a LONG datatype into another datatype. This is not allowed.
To solve this error, Do not try to insert LONG datatypes into other types of columns especially LONG.
Modify INSERT statement and write it correctly.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )