Oracle Error PLS-00572: improper constraint form used

Oracle Error Message

PLS-00572: improper constraint form used

Reason for the Error

“number” types cannot have a range. user-defined aggregate types and integer types cannot have scale or precision specified. Example: “x number(5,3)” is acceptable but “x number range 1..10” is not.

Solution

Remove the constraint