Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.