PL/SQL PACKAGE WITH CONDITIONAL COMPILATION FAILS WITH ORA-03113 AND ORA-07445 [pfrxca()] (Doc ID 1427064.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

A PL/SQL package with Conditional Compilation in the body fails with ORA-3113 and ORA-7445 [pfrxca()+89] when the specification is changed. After the specification is updated, the wrong code is called, followed by an ORA-3113 and ORA-7445:

BEGIN my_test.start; END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7074
Session ID: 136 Serial number: 19783

When the Conditional Compilation (see code below) is commented out, the
package works successfully.

$IF my_test.debug $THEN
   NULL;
$END

The ORA-7445 error trace shows:

ORA-07445: exception encountered: core dump [pfrxca()+89] [SIGSEGV]
[ADDR:0x0] [PC:0x93E5AD5]

with stack:

..., pfrxca, pfrinstr_XCAL, pfrrun_no_tool, pfrrun, plsql_run, peicnt,
kkxexe, opiexe, ...

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