I was running some installation of DB objects with “sqlplus” utility and this is what I got
SQL> @XX_OM_DRH_PROCESS_UTIL.pkb
create or replace package body XX_OM_DRH_PROCESS_UTIL is
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
The sad part is that the package is OK. If I open it in “PL/SQL Developer” I can compile it without any problems. But if I run it through “sqlplus” or “alter package XX_OM_DRH_PROCESS_UTIL compile” it gives me the error above.
I spend several hours trying to understand what can be wrong. One of my managers eventually provided the solution. All you need to do is to execute the following
SQL> alter session set events = '10932 trace name context level 32768';
Session altered.
SQL> @XX_OM_DRH_PROCESS_UTIL.pkb
Package body created.
SQL>
