Database Error Messages

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

ORA-40563

default value not allowed for object types

Cause

The error handler specified a default value and the returned data type was an object type. These cannot be combined.


Action

Use a scalar return type for the operator, or choose a different error handler such as 'NULL ON ERROR' or 'ERROR ON ERROR'.