When I am creating a dataframe on parquet files and writing it into Oracle DB, I am getting such error:
“Suppressed: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column”
The things I have checked:
The encoding in both oracle and spark is compatible and correct.
The source for parquet is oracle DB itself and target for the parquet is also Oracle DB and both the databases are having same encoding.
The datatype of the field has been modified as CLOB still I am getting the issue.
The datatype of the dataframe(created on the parquet file) field is string and the string length is maximum 52.
If you require more information please let me know, as I have searched about it too much and can not find anything.