Complex Query Fails with ORA-7445 [nsoexc()+152] or ORA-7445 [opitca()+5340]
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on 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.
- Patch 4683638 has not been applied
ORA-7445 [nsoexc()+152]CALL STACK
nsoexc nsoexc nsoboc nsolev nsolev kkqdrv ...
- Patch 4683638 has been applied
ORA-7445 [opitca()+5340]CALL STACK
opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock ...
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