My Oracle Support Banner

PL/SQL Conditional Compilation Results In ORA-03113/ORA-07445 KXEP_CHECK_INH_PRIVS_ Error (Doc ID 2431228.1)

Last updated on FEBRUARY 19, 2019

Applies to:

PL/SQL - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

PL/SQL code that uses conditional compilation fails with ORA-03113 error during compilation or run time. In alert log, you could see ORA-07445 KXEP_CHECK_INH_PRIVS_ error(s). For example:

ORA-07445: exception encountered: core dump [kgidmp()+296] [SIGSEGV] [ADDR:0x30] [PC:0xC1D6718] [Address not mapped to object] []
ORA-07445: exception encountered: core dump [kxep_check_inh_privs_()+128] [SIGSEGV] [ADDR:0x3C] [PC:0x2ABFEA0] [Address not mapped to object] []

Issue is seen only when using AUTHID CURRENT_USER along with conditional compilation. For example, the below anonymous PL/SQL block will fail with the said error.

Test case:

 

Changes

Database upgraded to 12.1.0.1.0 or higher. 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.