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

 

 

Highlighted
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now