My Oracle Support Banner

ORA-7445[kxspoac] Error Is Raised By A Query Using Bind Variables When Cursor_Sharing Is Not Set To EXACT (Doc ID 1247195.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.6 to 10.1.0.5 [Release 9.2 to 10.1]
Information in this document applies to any platform.

Symptoms

The following error is seen in the alert log:
     ORA-07445: exception encountered: core dump [kxspoac()+872]
     [SIGBUS] [unknown code] [0x000000000] [] []

The call stack can look like this:
     kxspoac opibnd0 opibnd opibrp opiall0 opial7 opiodr

The cursor_sharing parameter is NOT set to a value of 'EXACT.'

The failing SQL includes bind variables.

Cause

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.