ORA-01461: can bind a LONG value only for insert into a LONG column
Problem symptoms
- Using PRO * C or OCI.
- Database character set is set a multibyte character set. For example UTF8, AL32UTF8, JA16SJIS or JA16EUC.
- Trying to insert a VARCHAR2 into a column that is defined with a length of more than 1333 bytes.
- The same table either has another LONG column or at least one other VARCHAR2 with a length over 1333 bytes.
- NLS_LANG is set to a single-byte character set. For example american_america.WE8ISO8859P1)
Later we found that the version is jdbc not the same, and should use the same version of the database jdbc.
Tags: Long
Releated Java Articles
December 5, 2006 | Filed Under API for Java |






