My Oracle Support Banner

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

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.