procedureName

A procedureName represents a Java stored procedure. To create a procedure, use the CREATE PROCEDURE statement.

Syntax

[ schemaName. ] SQL92Identifier

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'