Oracle 26ai

ORA-01461

  • variable_position: The position of the bind variable with the value that exceeds the maximum VARCHAR2 length.

Cause

An attempt was made to use a bind value whose length exceeded the maximum VARCHAR2 length allowed for the database.


Action

  • If the MAX_STRING_SIZE database parameter is set to STANDARD, consider changing it to EXTENDED.
  • If it is already set to EXTENDED, consider changing the data type of the column to CLOB.