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-15073: diskgroup string is mounted by another ASM instance

1 Answers  


PCC-02450: Cursor was not declared in scrollable mode

1 Answers  


DRG-50400: maximum number of fuzzy match candidates exceeded: string

1 Answers  


ORA-13137: failed to generate tablespace sequence number

1 Answers  


ORA-19752: block change tracking is already enabled

1 Answers  






ORA-16730: Error executing dbms_logstdby.skip_txn procedure

1 Answers  


KUP-04028: conversion of character length to a number failed

1 Answers  


NZE-29014: Maximum fragment length extension is incorrect.

1 Answers  


ORA-16551: short string copied

1 Answers  


ORA-14642: Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-19595: archivelog string already included in backup conversation

1 Answers  


ORA-02441: Cannot drop nonexistent primary key

1 Answers  


Categories