Database Error Messages

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

ORA-40779

Truncation is not supported with data type in RETURNING clause.

Cause

An attempt was made to use the TRUNCATE keyword with a non-textual data type in the RETURNING clause. This is not supported.


Action

Remove the TRUNCATE keyword or change the RETURNING clause to use a textual data type like VARCHAR2 or CLOB.