ORA-22813 is Reported Using Collect Function
(Doc ID 2027609.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
A-Receiving ORA-22813 when executing a collect function in SQL
B-Reproduces even on versions where Bug 19720346 is fixed
C-The following was tested and did not solve the issue:
1-Setting NLS_LENGTH_SEMANTICS=byte Indicating The limit is not reached
2-Alter system set "_COMPLEX_VIEW_MERGING" = FALSE;
3-alter system set events '44410 trace name context forever, level 1' ;
D-Works if the data is limited Example when using:
where rownum < 7000
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