SQL-02153: Invalid character variable for use in a GET/SET statement
Cause: An host variable with type other than character, string or varchar was found as an item name (other than DATA item) in an ANSI Dynamic GET or SET descriptor statement.
Action: Host variable types for character items (other than the DATA item) in ANSI dynamic GET or SET descriptor statements must not be of type LONG or LONG VARCHAR. Redeclare the variable to be character, string or varchar type
SQL-02154
Custom Search


More Oracle errors
ORA-00232snapshot control file is nonexistent, corrupt, or unreadable
ORA-13383inconsistent network metadata: string
PLS-01710In a positioned DELETE or UPDATE statement, the cursor name must be of length 1
ORA-12452label tag string already exists
PCC-00011Already in a declare section at line number in file string
PGU-42014RENAMES clause must be at level 66
ORA-32607invalid ITERATE value in MODEL clause
DRG-50916last document string is less than first document
ORA-06525Length Mismatch for CHAR or RAW data
RMAN-06511RMAN retention policy is set to redundancy number
ORA-24087Invalid database user string
ORA-16413Unsupported database type for ONDEMAND archivelog destinations
ORA-06526Unable to load PL/SQL library
QSM-01105no primary key or row id in MV, string, is found for table, string
ORA-09968unable to lock file
TNS-12631Username retrieval failed
ORA-33270(DBERR05) Analytic workspace string already exists.
ORA-38606FI support threshold not between [0, 1]
ORA-47141Factor expression string not found
ORA-24203operation failed, queue table string.string has errors




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-32701Hang detected
ORA-10877error signaled in parallel recovery slave string
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16957SQL Analyze time limit interrupt
ORA-16766Redo Apply is stopped
ORA-16664unable to receive the result from a database
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
RMAN-08137WARNING: archived log not deleted as it is still needed
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
ORA-16665timeout waiting for the result from a database
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-55508Invalid input to Flashback Transaction Backout
ORA-00001unique constraint (string.string) violated




Your own TOP 20 Oracle errors
SQL-02153Invalid character variable for use in a GET/SET statement