I have a script that creates a table containing few fields with CLOB datatype.
But whenever I try to INSERT into this table I get the following error:

**Exception: ORA-01461: can bind a LONG value only for insert into a LONG column. Neither does the source table.
**
This happens when I try ingesting data into a table from a different oracle database using Airflow.

I don’t understand this error since this table does not have any LONG datatype column.

Any suggestions on how to fix this error and correctly insert the data into the table?

I tried recreating the table using NCLOB types but that didn’t work as well.

I tried including TO_CLOB() function within the SELECT statement.

I also tried including the TO_CLOB() function into the INSERT statement.