ORA-600 [Sorgetqb_1] With Connect By Prior Clause

(Doc ID 415648.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: to - 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...'

Example :

Current SQL statement for this session:
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:

ksedst ksedmp ksfdmp kgerinv kgeasnmierr sorgetqb qercbiPFetch qersoFetch qerjotFetch qerjotFetch qercbiFilterData qercbiFetch qerflFetchOutside

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