Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00573: cannot constrain scale, precision, or range of an
anchored type declaration
- 1 Answers
- 2987 Views
- I also Faced
- E-Mail Answers
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 |
PCC-00133: Command line option MODE=ANSI required with option NLS_LOCAL=YES
LSX-00256: empty character class expression
ORA-22324: altered type has compilation errors
ORA-27507: IPC error disconnecting from a port
ORA-32818: AQ queue string does not exist
ORA-34358: (MXDSS14) number other users reading
ORA-25155: column used in NATURAL join cannot have qualifier
ORA-24036: invalid SORT_ORDER column string specified for queue table
ORA-38459: XML Tag "string" not found for the XMLType attribute "string"
ORA-01125: cannot disable media recovery - file string has online backup set
ORA-14607: Tablespace was not specified for previous subpartitions in template but is specified for string
IMG-00556: incorrect number of gamma values
Oracle Errors 
