RecompileObj.txt
10-20-2001 Bikle
--------------------

This file displays syntax which recompiles objects which may
be invalidated by manipulations of the event table.

ALTER PROCEDURE LOG_EVENT_AUTONOMOUS          COMPILE;
ALTER PROCEDURE LOG_EVENT                     COMPILE;
ALTER PACKAGE   PKG_CALCULATE_SUMMARY         COMPILE BODY;
ALTER PACKAGE   PKG_CALCULATE_SUMMARY_MONTHLY COMPILE BODY;
ALTER TRIGGER   EVENT_TIME_TRIG               COMPILE;

Running the above commands on bikledev resulted in some errors:

21:30:28 SQL> ALTER PROCEDURE LOG_EVENT_AUTONOMOUS          COMPILE;

Procedure altered.

21:30:50 SQL> ALTER PROCEDURE LOG_EVENT                     COMPILE;

Procedure altered.

21:30:50 SQL> ALTER PACKAGE   PKG_CALCULATE_SUMMARY         COMPILE BODY;

Warning: Package Body altered with compilation errors.

21:30:51 SQL> ALTER PACKAGE   PKG_CALCULATE_SUMMARY_MONTHLY COMPILE BODY;

Warning: Package Body altered with compilation errors.

21:30:51 SQL> ALTER TRIGGER   EVENT_TIME_TRIG               COMPILE;

Trigger altered.

21:31:33 SQL> ALTER PACKAGE   PKG_CALCULATE_SUMMARY         COMPILE BODY;

Warning: Package Body altered with compilation errors.

21:31:56 SQL> show err
Errors for PACKAGE BODY PKG_CALCULATE_SUMMARY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
343/2    PL/SQL: SQL Statement ignored
345/7    PLS-00201: identifier 'MESSAGE' must be declared
349/2    PL/SQL: SQL Statement ignored
351/7    PLS-00201: identifier 'MESSAGE' must be declared
638/2    PL/SQL: SQL Statement ignored
640/7    PLS-00201: identifier 'MESSAGE' must be declared
644/2    PL/SQL: SQL Statement ignored
646/7    PLS-00201: identifier 'MESSAGE' must be declared