Protocol Violation While Using Clob With Definecolumntype()

(Doc ID 1300026.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version 11.2.0.1 to 11.2.0.2.0 [Release 11.2]
Information in this document applies to any platform.

Symptoms

While querying the CLOB field with defineColumnType(LONG_TEXT, Types.CLOB)
fails with following exception

Application uses 10.2.0.4 database with 11.2 JDBC driver

Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Protocol violation
at OrderProposalDelegateRaw.main(OrderProposalDelegateRaw.java:38)
Caused by: 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.doOCOMMIT(T4C7Ocommoncall.java:75)
at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:565)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3835)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3841)
at OrderProposalDelegateRaw.executeQuery(OrderProposalDelegateRaw.java:80)
at OrderProposalDelegateRaw.main(OrderProposalDelegateRaw.java:34)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms