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
Seven 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'.

Seven 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!

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.