Complex Query Fails with ORA-7445 [nsoexc()+152] or ORA-7445 [opitca()+5340]

(Doc ID 458850.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on any platform.

Symptoms

Problem Description

The following symptoms have been confirmed:

ERROR MESSAGE

ORA-7445 [nsoexc()+152]
CALL STACK

nsoexc nsoexc nsoboc nsolev nsolev kkqdrv ...
ERROR MESSAGE
ORA-7445 [opitca()+5340]
CALL STACK 
opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock ...

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