ERROR | Float cannot have scale |
CAUSE | When a FLOAT variable was declared, its precision and scale were specified, as shown in the following example: DECLARE Salary FLOAT(7,2); However, a scale for FLOAT variables cannot be specified; only a precision can be specified, as in salary FLOAT(7); |
ACTION | Remove the scale specifier from the declaration, or declare a NUMBER variable instead. |