Oracle Error PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration

Oracle Error Message

PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration

Reason for the Error

A variable declared with %TYPE or %ROWTYPE cannot have a scale, precision, or range constraint. Example: x y%TYPE(10) is not acceptable. It is legal to add “NOT NULL” or non-conflicting CHARACTER SET constraints to anchored type declarations.

Solution

Remove the constraint or use a type name instead of an anchored type.