PLS-00499: coercion into collection of records not supported
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-09701: scnfy: maximum number of processes exceeded
IMG-00808: unable to read an empty image
ORA-21614: constraint violation for attribute number [string]
PLS-01458: The set clause in an UPDATE statement requires a column name of length 1
ORA-30945: Could not create mapping table 'string'
AMD-00117: input file "string" not found
RMAN-08119: skipping backup piece handle string; already exists
RMAN-00574: rman aborting due to errors read/writing dbms_pipe
ORA-02809: Jump buffer not valid
ORA-12030: cannot create a fast refresh materialized view
TNS-02526: server proxy type does not match client type
ORA-32005: error while parsing size specification [string]