Ora-00600:[Qctcte1] Reported On A Select Query with an Aggregate Subquery
(Doc ID 435509.1)
Last updated on SEPTEMBER 24, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.3 [Release 10.2]
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 Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
The following error is reported when executing a Select query with an aggregate subquery:
ORA-00600: internal error code, arguments: [qctcte1], , , , , , , 
Stack functions are as follows:
qctcte qctooei qctown qctcopn qctcopn qctcopn qctcpqb qctcpqbl qctcpqb qctcpqbl
The failing query can be similar to:
SELECT 1 FROM t1 a, t2 b WHERE ( a.c1= b.c1) and (b.c2 = (select max(to_number(x.c2)) from t2 X where X.c1 = a.c1 and X.c3='1')) AND b.c3 = '1';
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