tOracleInput throwing error

[Anonymous]

 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.

[fdenis]

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

[Anonymous]

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

[muralam · Accepted solution]

Hi, 

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

Regards,

Meenas

[fdenis]

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