Oracle Error PLS-00494: coercion into multiple record targets not supported

Oracle Error Message

PLS-00494: coercion into multiple record targets not supported

Reason for the Error

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.

Solution

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