My Oracle Support Banner

Select Query with Connect By Clause Failing With ORA 600 [nsoFindCbyRWQbc:prior Strp] Error (Doc ID 2968730.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In 19c, Select query using Connect By clause failing with below ORA error
ORA-00600: internal error code, arguments: [nsoFindCbyRWQbc:prior strp], [], [], [], [], [], [], [], [], [], [], []

Main Stack:
nsoFindCbyRWQbc <- nsoexp <- nsoexp <- nsobop <- nsobop <- nsobop <- nsobop <- nsobop <- nsobop
<- nsobop <- nsobop <- nsobop <- nsobop <- nsocsqlz <- kkqudrv <- kkqdrv <- opiSem
<- opiDeferredSem <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksSetBindType <- kksfbc
<- opiexe <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc <- kpuexec
<- OCIStmtExecute <- qksanExecSql <- qksanAnalyzeSqlConCbk <- qksanAnalyzeSql
<- kkopmReproducePlan <- kkopmCostPlanBaseline <- kkopmSelectPlanBaseline
<- kkopmPlanBaselineCheck2 <- qkadrv2Post <- qkadrv2 <- opitca <- kksFullTypeCheck
<- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- opiexe <- kpoal8 <- opiodr
<- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.