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

Last updated on JULY 20, 2024

Applies to:

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

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