How to fix the Oracle error PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration?

In this post, you’ll learn more about the Oracle ErrorPLS-00573: cannot constrain scale, precision, or range of an anchored type declaration with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration ?

You can fix this error in Oracle by following the below steps

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