Oracle Error PLS-00400: different number of columns between cursor SELECT statement and return value

Oracle Error Message

PLS-00400: different number of columns between cursor SELECT statement and return value

Reason for the Error

In a cursor declaration, a return type (such as RETURN emp%ROWTYPE) was specified, but the number of returned column values does not match the number of select-list items.

Solution

Change the cursor return type or the select list so that the number of returned column values matches the number of select-list items.