Select Query on a Composite Partitioned Table with Bind Variables Fails with ORA-01008 (Doc ID 1951776.1)

Last updated on DECEMBER 10, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12cBETA2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Select query on a composite partitioned table with bind variables
fails with ORA-01008.

Trace file may show the failing query and stack as:

ORA-01008: not all variables bound
----- Current SQL Statement for this session (sql_id=4z28p2hucjrra) -----
SELECT distinct TBL$OR$IDX$PART$NUM("TXN2", 0, 1, 0, "TXN_MINUTE") FROM
(SELECT "AP"."TXN_MINUTE" "TXN_MINUTE" FROM "PAYMENTS_TO_AGGREGATE" "AP"
WHERE "AP"."AP_DATE"<TO_DATE(:B1) AND "AP"."AP_DATE">=TO_DATE(:B2)) ORDER BY
1

----- Call Stack Trace -----
skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction
<-dbgdRunActions <- dbgdProcessEventActions <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- ksfpec <- dbgePostErrorKGE
<- 1129 <- dbkePostKGE_kgsf <- kgeselv <- ksesecl0 <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack <- rpiswu2
<- kprball <- kkpapiItOpen <- kkpapiItOpen <- kkpapItOpen <- kkoiiu <- kkofmx <- kkonxc <- kkotap <- kkojnp <- kkocnp
<- kkooqb <- kkoqbc <- apakkoqb <- apaqbdDescendents <- apaqbdList <- apaqbdDescendents <- apaqbdList <- apaqbd
<- kkqctCostTransfQB <- kkqctdrvJF <- kkqjfgdtr <- kkqctInterleaveJF <- kkqctdrvTE <- kkqtedtr <- qksqbApplyToQbc
<- kkqctdrvTD <- kkqtedrv <- kkqdrv <- kkqctdrvIT <- apadrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksSetBindType
<- kksfbc <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- start

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