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-01902: SEGMENT keyword expected

1 Answers  


ORA-39096: invalid input value string for parameter string

1 Answers  


ORA-24338: statement handle not executed

1 Answers  


AMD-00113: PROCEDURE string, invalid operation

1 Answers  


ORA-02252: check constraint condition not properly ended

1 Answers  






ORA-07231: slemcc: invalid file handle, seals do not match.

1 Answers  


ORA-31514: change set string disabled due to capture error

1 Answers   Oracle,


ORA-00826: cannot set sga_target for an ASM instance

1 Answers  


ORA-28132: Merge into syntax does not support security policies.

2 Answers  


ORA-14150: missing SUBPARTITION keyword

1 Answers  


ORA-13043: failed to read metadata from the <layer>_SDOLAYER table

1 Answers  


TNS-12582: TNS:invalid operation

1 Answers  


Categories