PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration
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.
PLS-00580
Custom Search


More Oracle errors
ORA-02329column of datatype string cannot be unique or a primary key
ORA-13852Tracing for service(module/action) string is not enabled
ORA-25508database is not mounted
ORA-16650command incompatible when fast-start failover is enabled
DRG-11006invalid alter index parameter string
LPX-01075[XQST0075] Validate expression not supported
ORA-02038define is not allowed for array type
PCC-02375SQL statement found outside the body of a function
ORA-02391exceeded simultaneous SESSIONS_PER_USER limit
QSM-01344general inline view rewrite not possible on this WHERE clause construct
ORA-35280(SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] [USING aggmap-name] [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [FORCEORDER] [PARALLEL #] [{FROM|FROMVAR} fromname [, fromname2 ...]]
ORA-29706incorrect value string for parameter ACTIVE_INSTANCE_COUNT
SQL*Loader-00645error converting character length field to a number
ORA-36630(XSDUNION00) An empty base dimension list was specified in the concat dimension definition.
LPX-00005~1s buffer overflow, maximum size is ~2u bytes
DIA-48908No trace files are found
ORA-01544cannot drop system rollback segment
ORA-47105invalid object owner string for command string
ORA-28536error in processing Heterogeneous Services initialization parameters
ORA-22982cannot create sub-view under this view




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
PLS-00573cannot constrain scale, precision, or range of an anchored type declaration