Message Oracle PLS-00494 - coercion into multiple record targets not supported

ERRORcoercion into multiple record targets not supported
CAUSEThe 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.
ACTIONCreate a new record type to hold all of the column types or code the SELECT with an INTO target for every source column.