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 |
QSM-01075: materialized view, string, does not support aggregate function, string
ORA-14173: illegal subpartition-extended table name syntax
LPX-00121: undefined notation "~S"
RMAN-08126: keep attributes for the proxy copy are changed
ORA-33214: (CINSERT02) The workspace object dimension is too large.
ORA-01084: invalid argument in OCI call
TNS-12622: TNS:event notifications are not homogeneous
KUP-02001: unrecognized punctuation symbol "string"
PCC-02106: Userid only used when SQLCHECK = FULL, userid ignored.
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
ORA-31410: change set string is not an existing change set
RMAN-10038: database session for channel string terminated unexpectedly