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

Last updated on FEBRUARY 22, 2024

Applies to:

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 ----- FROM <table name>
WHERE <column name> <TO_DATE(:B1) AND <column name> >=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

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