tOracleInput throwing error

Six Stars

tOracleInput throwing error

 Hi,

 

tOracleInput component throwing below error when we are running this query.

 

SELECT V_OUT FROM TABLE(GRT_PIPE());

 

[FATAL]: artemis_dev.transactor_proc_withquery_0_1.Transactor_proc_WithQuery - tOracleInput_1 Fail to convert to internal representation
Exception in component tOracleInput_1
java.sql.SQLException: Fail to convert to internal representation
at oracle.jdbc.driver.CharCommonAccessor.getLong(CharCommonAccessor.java:297)
at oracle.jdbc.driver.T4CVarcharAccessor.getLong(T4CVarcharAccessor.java:852)
at oracle.jdbc.driver.OracleResultSetImpl.getLong(OracleResultSetImpl.java:971)
at artemis_dev.transactor_proc_withquery_0_1.Transactor_proc_WithQuery.tOracleInput_1Process(Transactor_proc_WithQuery.java:2884)
at artemis_dev.transactor_proc_withquery_0_1.Transactor_proc_WithQuery.tJava_1Process(Transactor_proc_WithQuery.java:2336)
at artemis_dev.transactor_proc_withquery_0_1.Transactor_proc_WithQuery.runJobInTOS(Transactor_proc_WithQuery.java:3397)
at artemis_dev.transactor_proc_withquery_0_1.Transactor_proc_WithQuery.main(Transactor_proc_WithQuery.java:3131)

 

 

Please let us know the root cause and how to fix this.


Accepted Solutions
Six Stars

Re: tOracleInput throwing error

Hi, 

 

please check the schema data types of the input component using also table schema and talend schema defined should be same

 

Regards,

Meenas

Eleven Stars

Re: tOracleInput throwing error

it is type problem, can you cast V_OUT as String
cast(V_OUT as NVARCHAR(20))

Francois Denis

Tag as "solved" for others! Kudos to thanks!


All Replies
Eleven Stars

Re: tOracleInput throwing error

what is TABLE(GRT_PIPE())
is it a function who retun Table?
what is your query result in an sql editor?

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Six Stars

Re: tOracleInput throwing error

It is a piplined function in Oracle.

that is the syntax to call oracle piplined function in Oracle.And it is running fin from sql developer.

Query will return all columns values (around 2 million records) which are under 'V_OUT'.

Six Stars

Re: tOracleInput throwing error

Hi, 

 

please check the schema data types of the input component using also table schema and talend schema defined should be same

 

Regards,

Meenas

Eleven Stars

Re: tOracleInput throwing error

it is type problem, can you cast V_OUT as String
cast(V_OUT as NVARCHAR(20))

Francois Denis

Tag as "solved" for others! Kudos to thanks!