Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-12700: invalid NLS parameter value (string)

1 Answers  


RMAN-05013: auxiliary control filename string conflicts with a file used by the target database

1 Answers  


ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 Answers  


ORA-16755: failed to set initialization parameter

1 Answers  


ORA-19583: conversation terminated due to error

1 Answers  






TNS-00309: Connection Manager: Failed to open log while re-reading parameter data

1 Answers  


ORA-00276: CHANGE keyword specified but no change number given

1 Answers  


TNS-00520: Syntax error

1 Answers  


ORA-12819: missing options in PARALLEL clause

1 Answers  


ORA-28261: CURRENT_USER can not be used in PLSQL Definer's Right procedure.

1 Answers  


ORA-26699: STREAMS message consumer string already exists

1 Answers  


ORA-12483: label not in OS system accreditation range

1 Answers  






Categories