SQL$HELP72.HLB  —  CREATE  MODULE
    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
Environment Format Arguments Examples
Close Help