To compile all program units:
In the Object Navigator, click the report or library for which you want to compile all program units (including PL/SQL subprograms, report triggers, formulas, group filters, format triggers, and validation triggers).
Choose ProgramCompile
All
to compile all program units, regardless of their current compilation status.
Note: An uncompiled program unit is indicated by an asterisk (*) after its name under the Program Units node in the Object Navigator. When you make changes to a program unit, dependent program units lose their compiled status.
In the Compile dialog box, click any error to navigate to the source of the error in the program unit. Tip: Check for missing semicolons at the end of statements, or misspelled syntax.
Compiling a single program unit
Compiling all uncompiled program units
Copyright © 1984, 2005, Oracle. All rights reserved.