Issue with data type

[_AnonymousUser]

Hi There,
I am using Datastage from last few years. I am analysing Talend and till now finding it quite good. I am stuck in defining a data type -
I am using following query in Oracle tOracleInput :
NVL(EXTRACT(MONTH FROM CAMPAIGN_START_DATE),'12') CAMPAIGN_MNTH
CAMPAIGN_MNTH is defined as integer but it gives data type error -
Exception in component tOracleInput_1
java.sql.SQLException: Fail to convert to internal representation
----
To counter issue I modified query to
to_char(NVL(EXTRACT(MONTH FROM CAMPAIGN_START_DATE),'12')) CAMPAIGN_MNTH now getting this error:-
ORA-01722: invalid number
---
I tried all data types but no luck.. So its not handling in short. Please advice what needs to be done.
Thanks!

[Anonymous]

@Alekhya05 

It has something to do with your data type in input DB (which seems to be in Big Decimal format) and the output String format.

Before going to other details, I would request you to put your query to a new post. The current post is 10 years old and is a closed post. So if you put a totally different subject in same post, it will dilute the purpose of creating multiple posts for each query.

Hope you understands.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Sure, thanks Nikhil. I have that query resolved. But have another question which I think I have posted already about Data Truncation error in Talend. I will post that as a new post.

Thanks,

Alekhya

[Anonymous]

Hi shong, 

can you please help me with this.

Exception in component tOracleInput_1
java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
at oracle.jdbc.driver.CharCommonAccessor.getBigDecimal(CharCommonAccessor.java:357)
at oracle.jdbc.driver.OracleResultSetImpl.getBigDecimal(OracleResultSetImpl.java:426)
at local_project.v8_cust_0_1.v8_cust.tOracleInput_1Process(v8_cust.java:3468)
at local_project.v8_cust_0_1.v8_cust.runJobInTOS(v8_cust.java:5097)
at local_project.v8_cust_0_1.v8_cust.main(v8_cust.java:4954)
[statistics] disconnected
Job v8_cust ended at 09:44 18/06/2019. [exit code=1]