# procedureName

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

## 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'

Parent topic: SQL identifiers