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 |
RMAN-08035: partial resync skipped, target database not mounted
RMAN-05508: SET NEWNAME TO NEW not allowed (datafile string)
ORA-30086: interval year-month result not allowed for datetime subtraction
ORA-19699: cannot make copies with compression enabled
ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
ORA-25141: invalid EXTENT MANAGEMENT clause
ORA-02299: cannot validate (string.string) - duplicate keys found
ORA-22130: buffer size [string] is less than the required size [string]
RMAN-06019: could not translate tablespace name "string"
PLW-07203: parameter 'string' may benefit from use of the NOCOPY compiler hint
what is error treshold?
ORA-09749: pws_look_up: port lookup failure