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

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

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

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