Modules

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.