SQL-02152: Invalid numeric variable for use in an array GET/SET statement
Cause: An host variable with type other than int or short for C or S9(4) or S9(9) binary or comp was used for an exact numeric with and array size > 1.
Action: Use only int or short for C or S9(4) or S(9) binary or comp for COBOL when supplying an exact numeric in conjunction with the for clause to indicate arrays. Specifically, display sign leading separate is not allowed in this context.
SQL-02153
Custom Search


More Oracle errors
ORA-31102Already locked in exclusive mode. Cannot add lock.
ORA-12830Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
ORA-15021parameter "string" is not valid in string instance
ORA-08006specified row no longer exists
NNL-00289Scheduled cache flush to occur in string
ORA-12075invalid object or field
OCI-21607memory cartridge service handle not initialized
ORA-00332archived log is too small - may be incompletely archived
ORA-25457evaluation function string returns failure
ORA-60008adding (string) blocks to index string.string with MAXSIZE (string)
PGU-39600TG TIP string, SFD string
RMAN-08305channel string: starting to check datafiles
ORA-14652reference partitioning foreign key is not supported
ORA-06950No error
ORA-56901non-constant expression is not allowed for pivot|unpivot values
KUP-04025field extends beyond end of record
SQL-02145Invalid dynamic descriptor
LSX-00123base type is required
RMAN-08301Edit init.ora file string. This PFILE will be used to create the database on the target platform
PLS-00609the OVERRIDING clause is not valid for SQLJ Object Types




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
SQL-02152Invalid numeric variable for use in an array GET/SET statement