Local Variable Names 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.