SQL-02151: Invalid host variable for exact numeric SET statement item
Cause: An host variable with an invalid type or length was used to get or set an exact numeric item in an ANSI dynamic statement.
Action: Make sure your host variable is and int or short for C or for COBOL, S9(4) or S9(9) binary/comp/display sign leading separate.
SQL-02152
Custom Search


More Oracle errors
NZE-29225Certificate already installed.
ORA-12807process queue could not receive parallel query message
ORA-25298Only immediate visibility mode supported for buffered message enqueue or dequeue
DIA-48314Invalid ADR Control parameter [string]
ORA-13538invalid value for baseline expiration (string)
RMAN-06208to mismatched status. Use CROSSCHECK command to fix status
ORA-32510cannot create watchpoint on unreadable memory
ORA-14007missing LESS keyword
ORA-01325archive log mode must be enabled to build into the logstream
NPL-00103unusable ASN.1 context
PGU-39301QM failure rc %4li, number
DRG-11444valid gist maxPercent values are string
PGU-41038TPNAME parameter was previously specified
ORA-23441object does not exist for refresh group template
ORA-12089cannot online redefine table "string"."string" with no primary key
NNL-01077Save Config on Stop string
ORA-19758failed to enable/disable block change tracking: out of SGA memory
ORA-23386replication parallel push cannot create slave processes
TNS-00553read failed
ORA-01981CASCADE CONSTRAINTS must be specified to perform this revoke




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-02151Invalid host variable for exact numeric SET statement item