tOracleInput throwing error

Seven 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

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

Seven 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

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

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog