Error OALL8 When Running Query in Sql Developer
(Doc ID 1089534.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle SQL Developer - Version 2.1.0 and later
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!