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-02374: conversion error loading table string.string

1 Answers  


DRG-11120: failed to write to file string

1 Answers  


ORA-32842: value for property string cannot be altered

1 Answers  


ORA-23407: object name string must be shaped like "schema"."object" or "object"

1 Answers  


ORA-02152: Invalid ALTER TABLESPACE ... RENAME option

1 Answers  






ORA-07242: slembfn: translation error, unable to translate error file name.

1 Answers  


ORA-30513: cannot create system triggers of INSTEAD OF type

1 Answers  


ORA-27018: BLKSIZE is not a multiple of the minimum physical block size

1 Answers  


PLS-00462: nested subprogram 'string' has to be REPEATABLE

1 Answers  


ORA-19206: Invalid value for query or REF CURSOR parameter

1 Answers  


ORA-13761: invalid filter

1 Answers  


ORA-36270: (XSCGMDLAGG03) The right-hand side of the AGGREGATION function includes duplicate values.

1 Answers  


Categories