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.