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-38609: FI Not enough memory for tree counting, requires at least stringKB

1 Answers  


RMAN-06005: connected to target database: string (DBID=string)

1 Answers  


PCC-02308: identifier required in this function declaration

1 Answers  


ORA-09830: snyAddPort: failed to perform a remote procedure call.

1 Answers  


NZE-28861: SSL connection would block

1 Answers  






RMAN-12015: configuration for string channel number is ignored

1 Answers  


ORA-02046: distributed transaction already begun

1 Answers  


ORA-00225: expected size string of controlfile differs from actual size string

1 Answers  


ORA-22892: scoped table "string" does not exist in schema "string"

1 Answers  


ORA-32401: materialized view log on "string"."string" does not have new values

1 Answers  


TNS-00044: INTCTL: You must have an INTCHG.ORA file to contact the Connection Manager

1 Answers  


ORA-19040: Element string does not match expected string.

1 Answers  


Categories