PLS-00494: coercion into multiple record targets not supported



PLS-00494: coercion into multiple record targets not supported..

Answer / guest

Cause: The INTO list of a SELECT or FETCH specified more
than a single record- type target and the column types
required coercion into a record to match the INTO list. This
is type checked as correct, but not yet supported.

Action: Create a new record type to hold all of the column
types or code the SELECT with an INTO target for every
source column.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12462: undefined compartment string for policy string

1 Answers  


O2F-00334: A user-defined type is listed more than once in the INTYPE file

1 Answers  


RMAN-06058: a current controlfile cannot be included along with a standby controlfile

1 Answers  


ORA-26082: load of overlapping segments on table string.string is not allowed

0 Answers  


ORA-30042: Cannot offline the undo tablespace

1 Answers  






ORA-07713: sksamtd: could not mount archival device (SYS$MOUNT failure)

1 Answers  


LCD-00215: parameter files nested too deep [string]

1 Answers  


ORA-22336: table contained 8.0 image format, must specify INCLUDING DATA

1 Answers  


QSM-01115: rollup took place on a column with a window function

1 Answers  


ORA-19595: archivelog string already included in backup conversation

1 Answers  


IMP-00028: partial import of previous table rolled back: number rows rolled back

1 Answers  


DRG-50862: failed to create new Oracle object

1 Answers  


Categories