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.