How to fix the Oracle error PLS-00494: coercion into multiple record targets not supported?

In this post, you’ll learn more about the Oracle ErrorPLS-00494: coercion into multiple record targets not supported with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00494: coercion into multiple record targets not supported

Reason for the Error PLS-00494: coercion into multiple record targets not supported

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.

How to fix the Error PLS-00494: coercion into multiple record targets not supported ?

You can fix this error in Oracle by following the below steps

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