Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

OCI-03094

Too many columns or values for dml_type, maximum max_cols
  • dml_type: The type of SQL statement: INSERT or UPDATE.
  • max_cols: The maximum number of columns or values allowed.

Cause

The INSERT or UPDATE statement has too many columns or values.


Action

Modify the SQL statement by limiting the number of columns and values to 1000 or 4000 depending on the database version.