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

ORA-07592: sspgprv: Error obtaining required privileges

1 Answers  


ORA-13426: invalid window parameter for subset operation

1 Answers  


RMAN-06730: no channel to restore a backup of the SPFILE

1 Answers  


ORA-02036: too many variables to describe with automatic cursor open

1 Answers  


ORA-30442: can not find the definition for filter string

1 Answers  






ORA-22057: bad integer length [string]

1 Answers  


ORA-02843: Invalid value for kernel flag

1 Answers  


ORA-13837: invalid HASH_VALUE

1 Answers  


ORA-38307: object not in RECYCLE BIN

1 Answers  


PCC-02398: Indicator ignored in this statement for this type

1 Answers  


DRG-10103: illegal value for argument: string

1 Answers  


QSM-01022: a more optimal materialized view than string was used to rewrite

1 Answers  


Categories