Oracle Error PLS-00407: ‘*’ not allowed here; a list of columns is required

Oracle Error Message

PLS-00407: ‘*’ not allowed here; a list of columns is required

Reason for the Error

An asterisk (*) was used as an abbreviation for a list of column names. However, in this context the column names must be written out explicitly.

Solution

Replace the asterisk with a list of column names.