Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  DECLARE  Routine  Arguments  parameter-list
    The optional parameters of the routine. For each parameter
    you can specify a parameter access mode (IN, OUT, and INOUT),
    a parameter name, a data type, and a passing mechanism (by
    DESCRIPTOR, LENGTH, REFERENCE, or VALUE).

    The parameter access mode (IN, OUT, and INOUT) is optional and
    specifies how the parameter is accessed (whether it is read,
    written, or both). IN signifies read only, OUT signifies write
    only, and INOUT signifies read and write. The parameter access
    mode defaults to IN.

    Only the IN parameter access mode may be specified with
    parameters to a function. Any of the parameter access modes (IN,
    OUT, and INOUT) may be specified with parameters to a procedure.

    The parameter name is prefixed with a colon (:).  The parameter
    name must be unique within the routine parameters.

    The data type is required and describes the type of parameter
    using either an SQL data type or a domain name.

    You cannot declare a parameter as the LIST OF BYTE VARYING data
    type.
Close Help