PLS-00457: expressions have to be of SQL types
Cause: an expression of wrong type is in USING or dynamic RETURNING clause. In USING or dynamic RETURNING clause, an expression cannot be of non-SQL types such as BOOLEAN, INDEX TABLE, and record.
Action: change the expression type to a SQL type.
PLS-00459
Custom Search


More Oracle errors
ORA-22871ALTER TYPE with REPLACE is not allowed for pure incomplete types
ORA-53023cannot delete or update a referenced rule or macro string
ORA-13704Invalid value "string" specified for parameter "string".
NNL-00298No cache dump currently scheduled
ORA-25178duplicate PCTTHRESHOLD storage option specification
RMAN-08542channel string: starting proxy archived log backup at string
ORA-29298Character set mismatch
LSX-00270hex-encoded binary has odd length
ORA-32817message system link string is not configured with a log queue for string
ORA-09353Windows 32-bit Two-Task driver unable to open event semaphore
ORA-29261bad argument
NNL-00306Server setting all statistic counters to zero
CLSD-01007The OCR/OCR mirror location was replaced by string.
ORA-12452label tag string already exists
ORA-19321Could not open HTTP connection to host (string): port (string)
PCB-00552The SQLCA and a SQLCODE variable cannot both be used
ORA-37016(XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
ORA-13432NULL or invalid blankCellValue
ORA-06525Length Mismatch for CHAR or RAW data
ORA-32613not a MODEL cell




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-00457expressions have to be of SQL types