The Procedure Header

Go Up to Creating Procedures

Everything before AS in the CREATE PROCEDURE statement forms the procedure header. The header contains:

• The name of the stored procedure, which must be unique among procedure and table names in the database.
• An optional list of input parameters and their data types. The procedure receives the values of the input parameters from the calling program.
• Optionally, the RETURNS keyword followed by a list of output parameters and their data types. The procedure returns the values of the output parameters to the calling program.

Topics

• Declaring Input Parameters
• Declaring Output Parameters