Variable arguments

Variable-argument procedures offer even more flexibility than generic-size arguments. With variable argument procedures, you specify only the VARARGS keyword in the argument_type_list. Users can specify from 0 to 64 input values of any supported data type as input arguments. For example:

TEST.TESTSCH(USR)=> CREATE PROCEDURE customer(VARARGS)
RETURNS VARCHAR(ANY) LANGUAGE NZPLSQL AS
BEGIN_PROC
    BEGIN
        remaining text omitted for example...

Within the body of the stored procedure, the code must process the input values and manage them as needed.

Use variable argument procedures to create one procedure that can be used for different combinations of input types. This process simplifies the development of stored procedures and reduces the need to create overloaded procedure definitions that do the same task for different types and numbers of arguments.