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

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

 

 

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.
Four Stars

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

iam using the source and target tables as oracle and giving the same length and datatype for the columns in the both source and target .

when trying to load the tables from database using talend getting the below .

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

The table contains some columns having Varchar2(4000).

Source db:

NLS_CHARACTERSET:  WE8ISO8859P1.

Target Db:

NLS_CHARACTERSET:  AL32UTF8.

 

If i loaded tables from manually using sql loader script im not getting any error.

Getting error only when im using talend to load the tables.

 

Please provided me the solution if ASAP.

Thanks,

Amrutha Vetcha