Error OALL8 When Running Query in Sql Developer
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.
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
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