In this post, you’ll learn more about the Oracle ErrorPLS-00572: improper constraint form used with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00572: improper constraint form used
Reason for the Error PLS-00572: improper constraint form used
“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.
How to fix the Error PLS-00572: improper constraint form used ?
You can fix this error in Oracle by following the below steps
Remove the constraint