Complex Query Fails with ORA-7445 [nsoexc()+152] or ORA-7445 [opitca()+5340]
(Doc ID 458850.1)
Last updated on APRIL 06, 2020
Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
- A complex query fails with ORA-7445.
- Depending on a possible installation of patch 4683638, both the argument of the ORA-7445 exception as well as the call stack function may differ.
The following symptoms have been confirmed:
- Patch 4683638 has not been applied
nsoexc nsoexc nsoboc nsolev nsolev kkqdrv ...
- Patch 4683638 has been applied
opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock ...
Patching bug 4683638 can results in ORA-7445 opitca()
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.