Defines a module as an object in an Oracle Rdb database. Stored
with the module are its functions and procedures. A function or
procedure written in SQL that resides with the data in a database
is called a stored function or stored procedure. Likewise, a
module stored in a database is called a stored module. A stored
routine refers to either a stored procedure or stored function.
You invoke a stored procedure with the CALL statement from a
simple statement procedure in embedded SQL, SQL module language,
or interactive SQL or with the CALL statement from within a
compound statement.
You invoke a stored function by specifying the function name in a
value expression.
SQL uses the concept of a module as its mechanism for storing,
showing, deleting, and granting and revoking privileges on stored
routines within a database. This means you cannot store, delete,
or grant and revoke privileges on individual stored routines.
Should you need to remove a stored routine, use the DROP FUNCTION
routine-name CASCADE or DROP PROCEDURE routine-name CASCADE
syntax.
In general, SQL operates on modules, not stored routines.
However, there are a few exceptions: DROP FUNCTION, DROP
PROCEDURE, RENAME, SHOW FUNCTION, SHOW PROCEDURE, and CALL. The
SHOW FUNCTION statement displays information about functions.
The SHOW PROCEDURE statement displays individual procedures in a
stored module. The CALL statement can invoke only a single stored
procedure.
Additional Information:
explode
extract