PLS-00499: coercion into collection of records not supported



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

Post New Answer

More Oracle Errors Interview Questions

QSM-01075: materialized view, string, does not support aggregate function, string

1 Answers  


ORA-14173: illegal subpartition-extended table name syntax

1 Answers  


LPX-00121: undefined notation "~S"

1 Answers  


RMAN-08126: keep attributes for the proxy copy are changed

1 Answers  


ORA-33214: (CINSERT02) The workspace object dimension is too large.

1 Answers  


ORA-01084: invalid argument in OCI call

4 Answers  


TNS-12622: TNS:event notifications are not homogeneous

1 Answers  


KUP-02001: unrecognized punctuation symbol "string"

1 Answers  


PCC-02106: Userid only used when SQLCHECK = FULL, userid ignored.

1 Answers  


ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

2 Answers  


ORA-31410: change set string is not an existing change set

1 Answers  


RMAN-10038: database session for channel string terminated unexpectedly

1 Answers  


Categories