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-08035: partial resync skipped, target database not mounted

1 Answers  


RMAN-05508: SET NEWNAME TO NEW not allowed (datafile string)

1 Answers  


ORA-30086: interval year-month result not allowed for datetime subtraction

1 Answers  


ORA-19699: cannot make copies with compression enabled

1 Answers  


ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist

1 Answers  






ORA-25141: invalid EXTENT MANAGEMENT clause

1 Answers  


ORA-02299: cannot validate (string.string) - duplicate keys found

2 Answers  


ORA-22130: buffer size [string] is less than the required size [string]

1 Answers  


RMAN-06019: could not translate tablespace name "string"

1 Answers  


PLW-07203: parameter 'string' may benefit from use of the NOCOPY compiler hint

1 Answers  


what is error treshold?

1 Answers  


ORA-09749: pws_look_up: port lookup failure

1 Answers  


Categories