A procedureName represents a Java stored procedure. To create a
procedure, use the .
Syntax[ 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.
Example-- 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'