PLS-00407

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

Causa: 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.

Acción: Replace the asterisk with a list of column names.