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 |
ORA-07592: sspgprv: Error obtaining required privileges
ORA-13426: invalid window parameter for subset operation
RMAN-06730: no channel to restore a backup of the SPFILE
ORA-02036: too many variables to describe with automatic cursor open
ORA-30442: can not find the definition for filter string
ORA-22057: bad integer length [string]
ORA-02843: Invalid value for kernel flag
ORA-13837: invalid HASH_VALUE
ORA-38307: object not in RECYCLE BIN
PCC-02398: Indicator ignored in this statement for this type
DRG-10103: illegal value for argument: string
QSM-01022: a more optimal materialized view than string was used to rewrite