Six Stars

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

Hello ,

Does anyone know how to convert Long value in hadoop to timestamp using tMap,  below are the errors i got, i have tried different options using Talendtime (e.g string to Date e.t.c ) but didnt work, i have also attached a screenshot of my map

 

thanks

Buks

 

 

 

[statistics] connecting to socket on port 3550
[statistics] connected
[WARN ]: org.apache.hadoop.io.compress.zlib.ZlibFactory - Failed to load/initialize native-zlib library
ORA-01461: can bind a LONG value only for insert into a LONG column

caused by: ORA-01461: can bind a LONG value only for insert into a LONG column
[ERROR]: sandbox_leapoc_project.fw_gz_hdfs_oracle_0_1.FW_GZ_HDFS_ORACLE - tOracleOutput_1 - ORA-01461: can bind a LONG value only for insert into a LONG column

caused by: ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-01483: invalid length for DATE or NUMBER bind variable

caused by: ORA-01483: invalid length for DATE or NUMBER bind variable
[ERROR]: sandbox_leapoc_project.fw_gz_hdfs_oracle_0_1.FW_GZ_HDFS_ORACLE - tOracleOutput_1 - ORA-01483: invalid length for DATE or NUMBER bind variable

caused by: ORA-01483: invalid length for DATE or NUMBER bind variable
ORA-01461: can bind a LONG value only for insert into a LONG column

caused by: ORA-01461: can bind a LONG value only for insert into a LONG column
[ERROR]: sandbox_leapoc_project.fw_gz_hdfs_oracle_0_1.FW_GZ_HDFS_ORACLE - tOracleOutput_1 - ORA-01461: can bind a LONG value only for insert into a LONG column

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

caused by: ORA-01461: can bind a LONG value only for insert into a LONG column
[ERROR]: sandbox_leapoc_project.fw_gz_hdfs_oracle_0_1.FW_GZ_HDFS_ORACLE - tOracleOutput_1 - ORA-01461: can bind a LONG value only for insert into a LONG column

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

caused by: ORA-01461: can bind a LONG value only for insert into a LONG column
[ERROR]: sandbox_leapoc_project.fw_gz_hdfs_oracle_0_1.FW_GZ_HDFS_ORACLE - tOracleOutput_1 - ORA-01461: can bind a LONG value only for insert into a LONG column

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

caused by: ORA-01461: can bind a LONG value only for insert into a LONG column
[ERROR]: sandbox_leapoc_project.fw_gz_hdfs_oracle_0_1.FW_GZ_HDFS_ORACLE - tOracleOutput_1 - ORA-01461: can bind a LONG value only for insert into a LONG column

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

 

 

  • Big Data
  • Data Integration
1 REPLY
Moderator

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

Hello,

What's your Input source and target? Are you using Oracle DB in your workflow? Oracle blob column? More information about your current situation will be preferred.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.