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-06816TLI Driver: could not set the SPX SAP address
ORA-36842(XSLMGEN12) Hierarchy string.string.string was not found
TNS-00501Cannot allocate memory
ORA-24082propagation may still be happening for the schedule for QUEUE string and DESTINATION string
ORA-13640The current operation was cancelled because it timed out, and was not in interruptible mode.
AUD-00613export destination access denied
ORA-25334Buffered propagation must restart as the destination queue was recreated/moved
ORA-38956Target platform string not cross platform compliant
ORA-14051invalid ALTER MATERIALIZED VIEW option
ORA-19618cannot name files after RESTOREVALIDATE has been called
ORA-38498invalid stored attribute for the index object : string
RMAN-08021channel string: restoring control file
ORA-09833addCallback: bad message format.
NNL-00273server successfully started
ORA-14658specified dependent table is not affected by this operation
ORA-28530Heterogeneous Services initialization error in NLS language ID
ORA-17503ksfdopn:string Failed to open file string
RMAN-06726could not locate archived log string
RMAN-10036RPC call OK on channel string
ORA-32133Cannot get stream from LOB/FILE




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