UPDATABLE is the default (versus CONSTANT) and allows the variable to be modified. An update of a variable can occur due to a SET assignment, an INTO assignment (as part of an INSERT, UPDATE, or SELECT statement), or as a procedure's OUT or INOUT parameter.