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:
Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and laterInformation 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 |