A procedureName represents a Java stored procedure. To create a procedure, use the CREATE PROCEDURE statement.
[ schemaName. ] SQLIdentifier
You can qualify a procedure name with a schemaName. If a qualified procedure name is specified, the schema name cannot begin with SYS.
-- SALES.TOTAL_REVENUE is a procedureName that includes a schemaName
CREATE PROCEDURE SALES.TOTAL_REVENUE(IN S_MONTH INTEGER,
IN S_YEAR INTEGER,
OUT TOTAL DECIMAL(10,2))
PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME
'com.example.sales.calculateRevenueByMonth'