Local variables are used to hold data within a procedure. A local
variable is declared in a DECLARE statement in the procedure, and it
is prefixed with a colon (:) when used in any other statement. Local
variable names must conform to ALLBASE/SQL's rules for basic names.