Nested table with Toracleinput

[Anonymous]

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.

[akumar2301]

What is Oracle version you are using ?

[Anonymous]

We are using both 11.2.0.4 and 12.2.1.0 Oracle version.

Regards,

Vivek

[manodwhb]

@vivek_u , check the below link.

https://community.talend.com/t5/Design-and-Development/tOracleInput-Protocol-violation-Cursor-size-l...

https://coderanch.com/t/302621/databases/java-sql-SQLException-Protocol-violation

[akumar2301]

Are you getting error in both version ?

Usually for 12.2 you should have ojdbc8.jar

https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html