Backport Request For Bug 14380605 On IBM Linux On System Z (Doc ID 2105388.1)

Last updated on FEBRUARY 10, 2016

Applies to:

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


ORA-01008 occurs and trace file shows SELECT 1 from dual on
The following will show in the trace file:


dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-01008: not all variables bound
----- Current SQL Statement for this session (sql_id=9ypua5j3jmcgn) -----
SELECT 1 FROM DUAL WHERE m.obj# = :objn and (:pobjn = 0 or
m.obj# = :pobjn or m.obj# in (select obj#
from tabpart$ where bo# = :pobjn a
nd obj# = :objn union all select obj#
from tabcompart$ where bo
# = :pobjn and obj# = :objn union all se
lect tsp.obj# from tabsubpart$ tsp, tabcompart$ tcp
where tsp.pobj# = tcp.obj# and ( = :pobjn or tcp.obj# = :pobjn)
and tsp.obj# = :objn))
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
3c3faf8f8 1906 package body SYS.DBMS_STATS
3c3faf8f8 44040 package body SYS.DBMS_STATS
3c3faf8f8 44256 package body SYS.DBMS_STATS



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