PLS-00572: improper constraint form used



PLS-00572: improper constraint form used..

Answer / guest

Cause: "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.

Action: Remove the constraint

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01530: a database already mounted by the instance

1 Answers  


TNS-12546: TNS:permission denied

2 Answers  


ORA-02083: database name has illegal character 'string'

1 Answers  


ORA-16578: failed to read Data Guard configuration file

1 Answers  


ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition

1 Answers  






ORA-01989: role 'string' not authorized by operating system

1 Answers  


PLS-00737: LIBRARY file specification exceeds the maximum allowed length

1 Answers  


ORA-31025: Invalid document element

1 Answers  


DRG-10835: WITHIN operator not supported for theme index

1 Answers  


ORA-13445: GeoRaster metadata SRS error

1 Answers  


RMAN-08104: input backupset count=string stamp=string creation_time=string

1 Answers  


ORA-14289: cannot make local index partition of Composite Range partitioned table unusable

1 Answers  


Categories