Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-13643: The task can not be interrupted or cancelled.

1 Answers  


ORA-01863: the year is not supported for the current calendar

1 Answers  


ORA-12601: TNS:information flags check failed

1 Answers  


ORA-24310: length specified for null connect string

1 Answers  


ORA-36188: (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.

1 Answers  






DRG-10583: TRUNCATE INDEX failed: string

1 Answers  


ORA-12843: pdml lock not held properly on the table

1 Answers  


PLS-00635: method does not override

1 Answers  


DRG-12409: syntax error for label in string

1 Answers  


O2F-00327: CASE option has an illegal value

1 Answers  


ORA-16782: some instance not open for read and write access

1 Answers  


TNS-00308: Navigator: Failed to open log while rereading parameter data

1 Answers  






Categories