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

PCC-02387: Expecting an expression of type sql_cursor

1 Answers  


ORA-24021: queue table definition not imported for string.string

1 Answers  


ORA-13619: The procedure argument string is greater than the maximum allowable length of string characters.

1 Answers  


ORA-15017: diskgroup "string" cannot be mounted

1 Answers  


PCC-00051: Size of VARCHAR string is larger than 65533 in line number in file string

1 Answers  






DRG-51017: unable to open storage buffer for fuzzy match candidates

1 Answers  


ORA-12855: cannot run parallel or insert direct load in a loopback

1 Answers  


PCC-00022: Out of space - unable to allocate number bytes

1 Answers  


NNL-00546: Displays delete request statistics

1 Answers  


ORA-07802: slbtpd: overflow while converting to packed decimal

1 Answers  


ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE

1 Answers  


NNL-00985: Requests reforwarded using referrals: number

1 Answers  


Categories