PLS-00217: NUMBER scale constraint must be in range (-84 .. 127)
Cause: A NUMBER variable was declared with a scale that is outside the legal range. Declarations such as N NUMBER(10,345) or N NUMBER(10,-100) are not supported.
Action: Change the illegal NUMBER scale constraint, making sure that it lies in the range -84 .. 127.
PLS-00218
Custom Search


More Oracle errors
SQL*Loader-00642Relative start position > absolute field end position.
ORA-15513cannot access the input directory
ORA-55711Unable to bind clusterwide global transactions to compatible undo
ORA-31517CDC change table string.string already exists
TNS-00284Imm Max Avg Bytes/Sec : number
ORA-29290invalid offset specified for seek
RMAN-07522CREATE TYPE privilege must be granted to user string
ORA-01947TEMPORARY TABLESPACE already specified
ORA-41015destination connect string not specified
ORA-01466unable to read data - table definition has changed
NZE-29235the key information could not be retrieved
ORA-16174user requested thread/sequence termination of managed recovery
ORA-30000missing either trim specification or char expression in TRIM
SQL-02157Source or destination lob is invalid
ORA-44707No source language translation found
ORA-12078fast refresh of refresh group ID string failed
ORA-39711critical patch number less than last installed CPU number
ORA-55514Backing out a DDL transaction
ORA-12204TNS:received data refused from an application
ORA-16535CRS is preventing execution of a broker operation




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
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
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-00217NUMBER scale constraint must be in range (-84 .. 127)