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

RMAN-06115: changed backup piece available

1 Answers  


NNL-01011: Forwarding contexts freed: number

1 Answers  


LFI-00114: Append is not allowed with string.

1 Answers  


ORA-30071: conversion between datetime/interval and string fail

1 Answers  


ORA-13837: invalid HASH_VALUE

1 Answers  






QSM-00776: the user-defined workload string is missing the following column: string

1 Answers  


PLS-00604: aggregate function is not allowed here

1 Answers  


ORA-01684: max # extents (string) reached in table string.string partition string

1 Answers  


ORA-24771: cannot detach, prepare or forget a local transaction

1 Answers  


ORA-24437: OCIStmtExecute called before OCIStmtPrepare2.

1 Answers  


SQL*Loader-00643: error executing INSERT statement for table string

1 Answers  


SQL*Loader-00309: No SQL string allowed as part of string field specification

1 Answers  


Categories