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-22632: AnyDataSet parameter is not valid for the current operation

1 Answers  


ORA-08196: Flashback Table operation is not allowed on AQ tables

1 Answers  


ORA-25275: Test support for buffered queues

1 Answers  


NZE-29106: Cannot import PKCS #12 wallet.

1 Answers  


RMAN-06100: no channel to restore a backup or copy of datafile number

1 Answers  






ORA-13239: sdo_dimensionality not specified during n-d R-tree creation

1 Answers  


ORA-13114: [string]_NODE$ table does not exist

1 Answers  


RMAN-06188: cannot use command when connected to a mounted target database

1 Answers  


PLS-00243: invalid external type specification for SQLNAME

1 Answers  


ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string

1 Answers  


RMAN-00563: password too long

1 Answers  


ORA-02204: ALTER, INDEX and EXECUTE not allowed for views

1 Answers  


Categories