Requirements for Stored Procedures

Stored procedures have a pre-defined structure and syntax. The type of stored procedure, either function or subroutine, must be declared, a name for the stored procedure, and arguments and their data types, if required, must be provided. The following sections elaborate on these requirements.

Conventions for Stored Procedures and Arguments

Arguments and their Data Types

The Compile Keyword (Optional)

The Contract Block