To compile a single program unit:
In the Object Navigator, under the Program Units node, click the program unit you want to compile (PL/SQL subprogram, report trigger, formula, group filter, format trigger, or validation trigger).
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 all uncompiled program units
Copyright © 1984, 2005, Oracle. All rights reserved.