Oracle Error Message
PLS-00401: different column types between cursor SELECT statement and return value found at ‘string’
Reason for the Error
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.
Solution
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.
