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-16100: not a valid Logical Standby database
ORA-04018: invalid value string for parameter _scn_scheme
ORA-23449: missing user name
O2F-00318: Error writing to the OUTTYPE file
ORA-00710: new tablespace name is the same as the old tablespace name
QSM-02066: Oracle error: see RELATED_NUM and RELATED_TEXT for details
ORA-30335: JOIN KEY clause references a level not in this hierarchy
ORA-22990: LOB locators cannot span transactions
ORA-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
ORA-23415: materialized view log for "string"."string" does not record the primary key
ORA-06546: DDL statement is executed in an illegal context
ORA-02090: network error: attempted callback+passthru