My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2020

Applies to:

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


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.