Ora-600 [Qctcte1] using connect by prior (Doc ID 361035.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Standard Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Aug-2012***

Symptoms

This was 10.2.0.2 on a Windows 2000 server.

Running a query gives an error. The error is consistent
and reproducible from sqlplus. It has never been successful.

The alert log shows the error
ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []

The trace file shows the failing statement
select rt.sfmenu_id,
level nivel,
rt.ar_rotina_id,
rt.rotina_id,
rt.ordem
from rotina rt
where exists (select 1
from sf_menu sf
where sf.sfmenu_id = rt.sfmenu_id
and sf.visivel = 'S'
and exists (select 1
from rotina rt2
where not exists (select 1 from menu_usu mn
where mn.rotina_id = rt2.rotina_id
and mn.usu_id = 323
and 0 = 0
union all
select 1
from menu_usu mn
, r_menusu_emprusu rme
where mn.rotina_id = rt2.rotina_id
and mn.usu_id = 323
and 1 = 0
and rme.menuusu_id = mn.menuusu_id
and rme.emprusu_id = 0) and exists (select 1
from sf_menu sfx
where sfx.sfmenu_id = rt2.sfmenu_id
and sfx.visivel = 'S' ) start
with rt2.ar_rotina_id = rt.rotina_id
connect by prior rt2.rotina_id = rt2.ar_rotina_id))
start with rt.ar_rotina_id is null
connect by prior rt.rotina_id = rt.ar_rotina_id

 

The call stack was:

ksedst ksedmp ksfdmp kgerinv kgeasnmierr
qctcte qctoreo qctcopn qctclog qctcpqb qctcpqbl qctcpqb
qctcpqbl qctcpqb qctcpqbl qctcpqb qctcpqbl xtydrv

Cause

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