• Compile - Compiles the procedure, logging any compilation messages in the result grid below.
  • To jump to the source of a compilation error, double-click on the line in the Compilation Messages grid
• Execute Procedure - Displays the Execute Procedure dialog to let the user specify parameters before execution.
  • To set a value, simply click on the parameter's Value cell and enter a value.
  • To execute, click the Execute button or click the Cancel button to abort execution

The Oracle Package Editor allows users to edit packages more easily by providing both the definition and the body in one tab window. The editor also provides a drop down of all functions & procedures in the package for quick navigation.