Protocol Violation Message In SQL Developer Worksheet when using with an Oracle Gateway (DG4ODBC, DG4MSQL, DG4SYBS, DG4DRDA)

(Doc ID 1434413.1)

Last updated on MARCH 12, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.3 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


When selecting with SQL Developer and an Oracle Gateway like Database Gateway for ODBC (=DG4ODBC), Database Gateway for MS SQL Server (=DG4MSQL), Database Gateway for Sybase (=DG4SYBS) or Database Gateway for DRDA (=DG4DRDA) from a remote foreign database table SQL Developer 3.1 fails with error:
Error: Protocol violation
SQLState: 99999
ErrorCode: 17401

Testing the same select in SQL*Plus is working fine.

Changes

Updating SQL developer from 3.0 to 3.1

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