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
- 3058 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 |
QSM-02128: does not meet the requirements of a primary key mv
ORA-01619: thread string is mounted by another instance
ORA-12493: invalid MLS binary label
LPX-00222: error received from SAX callback function
ORA-13342: an arc geometry has fewer than three coordinates
IMG-00854: internal image data free failed
ORA-01488: invalid nibble or byte in the input data
TNS-00548: value specified for client authentication parameter is not boolean
RMAN-06119: uncataloged datafile copy
PLS-00460: REPEATABLE subprogram 'string' has to be RNDS, WNDS, RNPS, and WNPS
QSM-01085: materialized view, string, has a lossy join between tables, string
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
Oracle Errors 
