A parenthetical comma-separated list of data types, including UDTs, and parameter names for the variables to be passed to the procedure.
You must specify opening and closing parentheses even if no parameters are to be passed to the procedure.
The maximum number of parameters you can specify in the parameter list depends on the language in which the external routine for the procedure is written:
Language | Maximum Number of Parameters |
---|---|
C or C++ | 256 |
Java | 255 |
- IN
- Parameter is input only. IN is the default parameter type. If the parameter type is not specified, the parameter is assumed to be of the IN type.
- OUT
- Parameter is output only.
- INOUT
- Parameter can be input and output.Vantage does not default to the data type you assign to an INOUT parameter when the procedure is called. Instead, it defaults to the smallest data type that can contain the specified input parameter. As a result, memory overflow errors can occur if an output parameter returned to an INOUT parameter cannot be contained by the default data type set for that parameter by the system.
- parameter_name
- Name of parameter name to pass to the procedure.
- data_type
- The data type associated with each parameter is the type of the parameter. For C and C++ procedures, all Vantage data types are valid. For Java procedures, all Vantage data types are valid except GRAPHIC and VARGRAPHIC.
- VARIANT_TYPE
- You can only specify the VARIANT_TYPE UDT type for callable input parameters within the body of the procedure using a NEW VARIANT_TYPE expression to pass dynamic UDTs into UDFs. You cannot declare a VARIANT_TYPE as an IN parameter data type for a procedure.
- TD_ANYTYPE
- You can specify the system-defined TD_ANYTYPE data type for an IN, OUT, or INOUT parameter.