PLS-00499: coercion into collection of records not supported
Cause: A SELECT or FETCH may specify a column list to be coerced into a variable which is a collection of records. This is type checked as correct, but not yet supported because of the implicit layout change required.
Action: Express the SELECT with an object constructor around the columns and use a collection of objects as an INTO variable. Or, build the collection one row at a time coercing each row into a record which happens to be an element. Or, use a record of collections.
PLS-00500
Custom Search


More Oracle errors
ORA-31461logfile location string contains no files that match pattern string
TNS-00269OFF
RMAN-03011Recovery Managerstring
ORA-31533only one change set (string) is allowed in change source
RMAN-05019WARNING: no channel of required type allocated to recover copy of datafile number
ORA-32130invalid offset/index refrenced in Bytes
ORA-16270PL/SQL procedure skipped due to unmaintained standby objects
ORA-14658specified dependent table is not affected by this operation
NZE-29158Unable to open library.
NNL-00292Scheduled statistic counters to be reset in string
ORA-12677Authentication service not supported by database link
DIA-48221Key Exceeds Maximum Allowed Length [string] [string] [string]
PLS-00708Pragma string must be declared in a package specification
OCI-31018Error deleting XML document
ORA-09948Process information label retrieval failed.
ORA-32809foreign queue string is already registered
ORA-30338illegal dimension hierachy name
ORA-13415invalid or out of scope point specification
RMAN-08608Initiated recall for the following list of remote backup files
PLS-00925native compilation failed: Unable to create file (string string)




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-00499coercion into collection of records not supported