Database Error Messages

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

ORA-06504

PL/SQL: Return types of Result Set variables or query do not match

Cause

Number and/or types of columns in a query does not match declared return type of a result set variable, or declared types of two Result Set variables do not match.


Action

Change the program statement or declaration. Verify what query the variable actually refers to during execution.