Error OALL8 When Running Query in Sql Developer (Doc ID 1089534.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 2.1.0 and later
Information in this document applies to any platform.

Symptoms

Getting error when trying to run a query in SQL Worksheet, either by "Run Statement" or "Run Script".
Running same query using SQL*Plus works.

Applying <Note 579400.1> does not resolve the issue.
Same scenario using different combinations of connection types (basic, tns), roles (default, sysdba) and database versions (9i, 10.2).

3 errors can be seen:
A)   OALL8 is in an inconsistent state
B)   Bigger type length than Maximum
C)   Protocol violation

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