Database Error Messages

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

ORA-40478

output value too large (maximum: string)

Cause

The provided JavaScript Object Notation (JSON) operator generated a result which exceeds the maximum length specified in the RETURN clause.


Action

Increase the maximum size of the data type in the RETURNING clause or use a CLOB or BLOB in the RETURNING clause.