This statement creates a Java external stored procedure using the ST_Geometry data type for the input parameter G1:
CREATE PROCEDURE get_Geom(IN G1 ST_Geometry, OUT A1 INTEGER) LANGUAGE JAVA NO SQL PARAMETER STYLE JAVA EXTERNAL NAME 'UDF_JAR:UserDefinedFunctions.get_Geom'; public static void get_Geom(java.sql.Clob G1, int[] A1) throws SQLException