Creating the Package Body

Package Body Syntax

The package body must complete the implementation for all procedures or functions declared in the package specification.

• Specify the OR REPLACE option to overwrite an existing package body.
• Define the subprograms in an appropriate order. The basic principle is that you must declare a variable or subprogram before it can be referenced by other components in the same package body. It is common to see all private variables and subprograms defined first and the public subprograms defined last in the package body.

CREATE [OR REPLACE] PACKAGE BODY package_name 
IS|AS
  private type and variable declarations
  subprogram bodies
  [BEGIN initialization statements]
END [package_name];