PLS Database Error Messages

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

oracle

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/