This statement creates a Java external stored procedure using the PERIOD data type for:
- Input parameters P1 and P2
- Output parameter P3
REPLACE PROCEDURE PDT_UDF(IN P1 PERIOD(DATE), IN P2 PERIOD(DATE), OUT P3 PERIOD(DATE)) LANGUAGE JAVA NO SQL PARAMETER STYLE JAVA EXTERNAL NAME 'UDF_JAR:UserDefinedFunctions.pdt_udf'; public static void pdt_udf(java.sql.Struct p1, java.sql.Struct p2, java.sql.Struct[] p3) throws SQLException