ORA-07445 [qkexrXformAndOr] in 11.2.0.2 Oracle Database Server (Doc ID 1292805.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms


SELECT FROM table fails with ORA-7445 [qkexrXformAndOr] when it uses a SUBQUERY in a CURSOR() call.
The SUBQUERY contains EXISTS.

Changes

1. Issue reproduces in 11.2.0.2
2. Issue doesn't reproduce in 11.2.0.1
3. Issue reproduces at will
4. Issue doesn't reproduce if EXIST is not present
5. Issue reproduces if EXIST is replaced with IN / NOT IN
6. The issue has been seen also for the following query generated by Oracle Transportation Management application:

select gm_group, gm_type, gm_class, gm_redirect, gm_description, cursor (select distinct gm_member from groupmembers g2 where g2.gm_group=g.gm_group and (g2.gm_member='everyone' or exists (select rowid from groupmembers g3 where g2.gm_member=g3.gm_group) or exists (select rowid from gl_user where g2.gm_member=gl_user_gid)) order by gm_member) from groupmembers g where gm_member='*' and gm_group=:1 order by gm_group

7. Issue doesn't reproduce if t2.member='everyone' is eliminated
8. In OTM 6.1 and 6.2 this query is not used. This query was used in 6.0 and earlier.

Call stack:

...<-qeesTraverseExpr <- qkexrXformOpn <- qkxrXformOpn <- qerflAllocate <- qknRwsAllocateTree <- ...


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