PLS-00510
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.