topic Re: tOracleInput throwing error in Talend Studio

tOracleInput throwing error

Anonymous — Mon, 25 Jun 2018 12:35:30 GMT

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.

Re: tOracleInput throwing error

fdenis — Mon, 25 Jun 2018 13:12:28 GMT

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

Re: tOracleInput throwing error

Anonymous — Mon, 25 Jun 2018 14:13:24 GMT

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

Re: tOracleInput throwing error

muralam — Mon, 25 Jun 2018 14:31:23 GMT

Hi,

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

Regards,

Meenas

Re: tOracleInput throwing error

fdenis — Mon, 25 Jun 2018 14:31:50 GMT

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