You can specify the ARRAY type as parameters and return types for UDFs written in C, C++, or Java. This includes scalar and aggregate UDFs, table functions, and table operators.
You can specify the ARRAY type as IN, INOUT, and OUT parameters of stored procedures and external stored procedures written in C, C++, or Java.
You can specify the ARRAY type as parameters and return types for UDMs written in C or C++.
ARRAY FNC functions and Java classes and methods are provided to enable a UDF, UDM, or external stored procedure to access and set the values of the elements in an ARRAY, or to get information about the ARRAY type parameter.