PLS-00401: different column types between cursor SELECT statement and return value found at string

PLS-00401: different column types between cursor SELECT statement and return value found at string

Cause: In a cursor declaration, a return type (such as RETURN emp%ROWTYPE) was specified, but a returned column value and its corresponding select-list item have different datatypes.

Action: Change the cursor return type or the select list so that each returned column value and its corresponding select-list item have the same datatype.