Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00573: cannot constrain scale, precision, or range of an
anchored type declaration



PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration..

Answer / guest

Cause: A variable declared with %TYPE or %ROWTYPE cannot
have a scale, precision, or range constraint. Example: x
y%TYPE(10) is not acceptable. It is legal to add "NOT NULL"
or non-conflicting CHARACTER SET constraints to anchored
type declarations.

Action: Remove the constraint or use a type name instead of
an anchored type.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00265: read failed from to host ~s

1 Answers  


ORA-16643: unable to determine location of broker configuration files

1 Answers  


ORA-28593: agent control utility: command terminated with error

1 Answers  


ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

1 Answers  


QSM-02049: subquery using the ANY clause in mv

1 Answers  






NID-00451: Succesfully changed database name.

1 Answers  


ORA-39044: Metadata transform string has already been specified.

1 Answers  


EXP-00027: failed to calculate ORACLE block size

1 Answers  


DRG-10305: pipe string is full

1 Answers  


ORA-36681: (XSDPART19) Partitions string and string are out of order.

1 Answers  


DRG-50934: parser hash create failure

1 Answers  


PCC-02342: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause

1 Answers  






Categories