Oracle Error Message
PLS-00510: Float cannot have scale
Reason for the Error
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);
Solution
Remove the scale specifier from the declaration, or declare a NUMBER variable instead.
