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-07619: $IDTOASC failed translating an integrity level
ORA-16809: multiple warnings detected for the database
ORA-12424: length exceeds binary label size
ORA-22892: scoped table "string" does not exist in schema "string"
TNS-00550: disconnection error
RMAN-08017: channel string: starting archive log restore to default destination
DRG-13310: index owner does not have EXECUTE privilege on USER_LEXER stored procedure string
ORA-13520: Database id (string) not registered, Status = string
RMAN-06474: maintenance channels are not allocated
ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable
NZE-28761: element creation failure
ORA-09763: osnmpx: send/receive error exchanging Mach ports.