Package components (PL/SQL)

Packages consist of two main components: the package specification and the package body.

• The package specification is the public interface, comprising the elements that can be referenced outside of the package. A package specification is created by executing the CREATE PACKAGE statement.
• The package body contains the actual implementation of all of the procedures and functions that are declared within the package specification, as well as any declaration of private types, variables, and cursors. A package body is created by executing the CREATE PACKAGE BODY statement.