PL/SQL PACKAGE WITH CONDITIONAL COMPILATION FAILS WITH ORA-03113 AND ORA-07445 [pfrxca()]
(Doc ID 1427064.1)
Last updated on OCTOBER 05, 2022
Applies to:
PL/SQL - Version 11.2.0.2 and laterInformation 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 |