When the ENABLE_LOB_VARIABLES database option is ON (the default is OFF), unsupported implicit conversions of large object (LOB) variables are not performed automatically, even if the data length is less than 32K. Existing SQL code that uses variables of LONG VARCHAR or LONG BINARY data type may require an explicit cast. In all cases, the LONG VARCHAR or LONG BINARY variable is cast down. For example, a LONG VARCHAR variable is cast down to a VARCHAR data type.
