Restrictions on the use of modules are good to note before
defining modules or when troubleshooting problems related to their
use.
The following restrictions apply to the use of modules:
- Granting privileges on individual objects within a module is not
supported. Only the EXECUTE privilege can be granted on or revoked
from the module.
- By definition, modules can only include definitions of the following
database objects:
- SQL procedures
- SQL functions
- External procedures
- External functions
- Created conditions
- A module initialization procedure for implicit execution upon
module initialization
- User-defined data type definitions including: distinct type, array
type, associative array type, row type, and cursor type
- Global variables of all data types
- By definition, the SYS_INIT initialization procedure which is
used to initialize a module cannot reference parameters or return
result sets.
- Defining, altering, initializing or
dropping modules is not supported from Data Studio tools.
In this version, the following restrictions apply to the use of
modules:
- Definition and execution of the initialization procedure is not
supported.