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
- 3048 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 |
ORA-01489: result of string concatenation is too long
ORA-26520: internal memory failure
LSX-00162: string "~S" is an invalid default for the complex type
RMAN-06006: connected to target database: string (not mounted)
ORA-13451: GeoRaster metadata scaling function error
ORA-30386: invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
LSX-00167: defining form of "~S" must occur at the top level
ORA-16773: Error in starting the physical apply service (MRP process)
LCD-00204: left parenth and no parameter specified [string]
NZE-28762: failure to add element
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
ORA-24300: bad value for mode
Oracle Errors 
