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

LSX-00122: value is not valid restriction of parent's whiteSpace

1 Answers  


PCC-02311: cannot have VARCHAR bit fields

1 Answers  


ORA-22975: cannot create a PRIMARY KEY-based REF to this object view

1 Answers  


ORA-08464: input raw decimal data contains more than 42 digits

1 Answers  


ORA-27190: skgfrd: sbtread2 returned error

1 Answers  


ORA-38761: thread string redo log sequence number string could not be accessed

1 Answers  


ORA-29251: Index1 is greater than Index2 in call to dbms_sql.bind_array

1 Answers  


ORA-28263: Insufficient memory in global context pool

1 Answers  


ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT

1 Answers  


ORA-09857: smprset: vm_protect error while protecting pga.

1 Answers  


ORA-14644: table is not subpartitioned by Hash method

1 Answers  


ORA-27196: skgfpbk: sbtpcbackup returned error

1 Answers  


Categories