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.