ORA-600 [Sorgetqb_1] With Connect By Prior Clause
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.2 to 10.2.0.3 - Release: 10.2 to 10.2
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
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