The declaration of a package has two parts
-
package specification - contains the declarations of procedures (and functions), variables, constants, and exceptions that are accessible outside the package
-
package body: defines procedures (and functions), cursors, and exceptions that are declared in the package specification.
-
It also defines those PL/SQL program units and constructs (procedures, variables etc) that are only local to the package body
-
The package specification is created by CREATE PACKAGE command
-
The package body is created by CREATE PACKAGE BODY command
|
