This statement creates a structured UDT named CIRCLE:
CREATE TYPE CIRCLE AS (x double, y double, r double);
This statement creates a Java external stored procedure using the CIRCLE structured UDT as the data type for the input parameter A1:
CREATE PROCEDURE MyCircle(IN A1 CIRCLE, OUT A2 INTEGER) LANGUAGE JAVA NO SQL PARAMETER STYLE JAVA EXTERNAL NAME 'UDF_JAR:UserDefinedFunctions.mycircle'; public static void mycircle(java.sql.Struct A1, int[] A2) throws SQLException