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

TNS-01095: %s * string * string * number

1 Answers  


RMAN-06083: error when loading stored script string

1 Answers  


ORA-12712: new character set must be a superset of old character set

1 Answers  


ORA-28172: distinguished name not provided by proxy

1 Answers  


QSM-01565: equivalence, string, cannot compute measure, string, in the query

1 Answers  






PLS-00384: type mismatch found at 'string' in UPDATE's SET clause

1 Answers  


ORA-23367: table string is missing the primary key

1 Answers  


QSM-01522: a more optimal equivlanece than string was used to rewrite

1 Answers  


RMAN-06476: channel number out of range (1-254): number

1 Answers  


ORA-38708: not enough space for first flashback database log file

2 Answers  


ORA-02031: no ROWID for fixed tables or for external-organized tables

1 Answers  


ORA-15072: command requires at least string failure groups, specified only string

1 Answers  


Categories