A module is a database object that is a collection of other
database objects such as functions, procedures, types, and variables.
The following topics provide information about modules and tasks
related to module use:
Features of modules
Modules have multiple features that make them useful database
objects.
Uses of modules
Modules are used primarily to group object definitions
together that have a common business purpose or use.
Restrictions on modules
Restrictions on the use of modules are good to note before
defining modules or when troubleshooting problems related to their
use.
Creating modules
Creating modules is a task that you would perform when
you have identified a set of routines, data types, and variables that
support a common business need and you want to create them together
within a common namespace for easier management and deployment.
Granting and revoking privileges on modules
Granting and revoking privileges on modules is a task that
you would perform when you want to allow or disallow users of the
database to be able to reference objects defined within the module
as part of a security practice.
Dropping modules
Dropping modules is a task that can be done when you no
longer require any of the objects defined within the module or the
module itself.
Referencing objects defined in modules
Referencing objects defined in modules can be done from
within a module or from outside of the module. The ability to reference
objects defined in modules also depends on whether the objects in
the module have been published or not.
Built-in modules
The built-in modules provide an easy-to-use programmatic
interface for performing a variety of useful operations.