ORA-600 [Sorgetqb_1] With Connect By Prior Clause
(Doc ID 415648.1)
Last updated on MARCH 20, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.2 to 10.2.0.3 [Release 10.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
1. ORA-600[sorgetqb_1] when running a request that has the clause 'connect by prior...'
select sys_connect_by_path(lst, :"SYS_B_0") as path from
(select t1.lst, t1.list from listlists t1, lists t2 where t1.list=t2.id)
where list=:p1 connect by prior list=lst start with lst=:p2
2. Call Stack Trace from the trace file:
3. This problem is reproducible when using:
OPTIMIZER_MODE = first_rows, first_rows_n
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