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.