Example: ARRAY Parameter in a Java External Stored Procedure - Teradata Vantage - Analytics Database

CREATE TYPE phonenumbers_ary AS CHAR(10) ARRAY[5];

REPLACE PROCEDURE getPhoneNums(IN A1 phonenumbers_ary, 
                               IN EMPID INTEGER, OUT myphonenum INTEGER)
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA 
EXTERNAL NAME 'UDF_JAR:UserDefinedFunctions.getPhoneNums';

public static void getPhoneNums(java.sql.Array A1, int empid, int[] myphonenum)