DECLARE statement is used to
define various items local to a program:
statements are not supported until MySQL 5.5.
Declarations must follow a certain order. Cursors must be declared before declaring handlers, and variables and conditions must be declared before declaring either cursors or handlers.