topic Re: Nested table with Toracleinput in Talend Studio

Nested table with Toracleinput

Anonymous — Fri, 12 Apr 2019 10:06:00 GMT

Hi,

We are getting below error when we use sql query for nested table in TOracleInput component.

Below is the query :

select * from NT_PP a,table(ob_pp);

Below is the error:

[FATAL]: artemis_dev.test3_0_1.Test3 - tOracleInput_1 Protocol violation
Exception in component tOracleInput_1
java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:459)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:61)
at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:498)
at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:3931)
at artemis_dev.test3_0_1.Test3.tFileInputDelimited_1Process(Test3.java:2561)
at artemis_dev.test3_0_1.Test3.runJobInTOS(Test3.java:3709)
at artemis_dev.test3_0_1.Test3.main(Test3.java:3464)

We are uning ojdbc driver ojdbc6.jar with 6.3.1 Talend version.

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