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

QSM-01004: no query rewrite before view merging

1 Answers  


LPX-00000: normal, successful completion

1 Answers  


SQL-02143: Target object has not been properly allocated

1 Answers  


ORA-30453: summary contains AVG without corresponding COUNT

1 Answers  


ORA-02374: conversion error loading table string.string

1 Answers  






ORA-02032: clustered tables cannot be used before the cluster index is built

1 Answers  


CLSS-00002: unable to determine local node number. type string

1 Answers  


ORA-00102: network protocol string cannot be used by dispatchers

1 Answers  


ORA-24365: error in character conversion

1 Answers  


ORA-22341: cannot assign supertype instance to subtype

1 Answers  


TNS-01026: Start Date string

1 Answers  


ORA-01578: ORACLE data block corrupted (file # string, block # string)

1 Answers  


Categories