Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ORA-01461: can bind a LONG value only for insert into a LONG column (JDBC Driver: 23.3.0.23.09)

Alexander SuterNov 21 2023

I'm 100% the given error is not correct.

When I update a record with the following values in exactly this given ORDER on a VARCHAR(200 CHAR) field with a prepared statement, then it fails with an ‘ORA-01461: can bind a LONG value only for insert into a LONG column’

Values: "łajdecki", "ସମ୍ଭବତ। |", "ربما", "тестирование", "światowid", "źrebak", "καλή", "東", “żaba”

Example:

  • First I update the same record and set "łajdecki"
  • Then I set on the same record "ସମ୍ଭବତ। |"
  • ..
  • until “żaba” and this is then failing
Comments
Post Details
Added on Nov 21 2023
2 comments
122 views