Float data types, such as FLOAT
, DOUBLE PRECISION
, and REAL
cannot have a scale constraint. Trying to
specify a scale results in the exception PLS-00510: Float cannot have scale being raised.
Noncompliant code example
DECLARE
foo FLOAT(10, 3); -- Noncompliant - raises PLS-00510
BEGIN
NULL;
END;
/
Compliant solution
DECLARE
foo FLOAT(10); -- Compliant
BEGIN
NULL;
END;
/