My Oracle Support Banner

ORA-00600:[kkoUpdateFroAnn:invalid Aptyp] for Query with NOT IN Operator (Doc ID 2614469.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

ORA-00600:[kkoUpdateFroAnn:invalid aptyp], [0], [0], [], [], [], [], [], [], [], [], [

----- Current SQL Statement for this session  -----

SELECT xxxxxxxxxxxxxxxxx
FROM xxxxxxxxxxxxxxxx
WHERE xxxxxxxxxxx = xxxxxxxxxxxxxxxxxxx
xxxx NOT IN
(SELECT......................)
...

Stack Trace:
kkoUpdateFroAnn <- kkoipt <- kkoqbc <- apakkoqb <- apaqbdDescendents
<- apaqbdDescendents <- apaqbdDescendents <- apadrv <- opitca <- kksFullTypeCheck
<- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor
<- opiosq0 <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- ssthrdmain <- main

 

Cursor#3(0x7f42d7c42228) state=SYNTAX

 

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.