This example shows the DDL for a Java external stored procedure with an XML data type as an input parameter:
SHOW PROCEDURE get_XML; *** Text of DDL statement returned. *** Total elapsed time was 1 second. --------------------------------------------------------------------- REPLACE PROCEDURE get_XML(IN X1 XML, INOUT A1 INTEGER) LANGUAGE JAVA NO SQL PARAMETER STYLE JAVA EXTERNAL NAME 'UDF_JAR:UserDefinedFunctions.get_XML(java.sql.SQLXML, int[])’;