Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
536 views