Example: Creating a Java External Stored Procedure Using a DATASET Data Type - Teradata Vantage

This statement creates a Java external stored procedure using the DATASET data type for the input parameter dataset_in and output parameter dataset_out:

CREATE PROCEDURE dst_xsp(IN dataset_in DATASET(8000) Storage Format Avro,
                          OUT dataset_out DATASET(8000) Storage Format Avro)
LANGUAGE JAVA 
NO SQL 
PARAMETER STYLE JAVA
EXTERNAL NAME 'JarXSP1:dst_xsp1.dst_xsp(java.sql.Blob, byte[][])';

public static void dst_xsp(java.sql.Blob b,
                           byte[][]vb_out) throws SQLException