Structure of Procedures

The body of a procedure consists of a compound statement.

A compound statement consists of a BEGIN and an END, enclosing a set of SQL statements. Semicolons delimit each statement.

• SQL Statements Allowed in Procedures
  You can use almost all SQL statements within procedures, including the following:
• Declaring Parameters for Procedures
  Procedure parameters appear as a list in the CREATE PROCEDURE statement.
• Passing Parameters to Procedures
  You can take advantage of default values of stored procedure parameters with either of two forms of the CALL statement.
• Passing Parameters to Functions
  UDFs are not invoked with the CALL statement, but are used in the same manner that built-in functions are used.