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. 

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • Facebook
  • DotNetKicks
  • DZone
  • Netvouz
  • Propeller

Tags:

Releated Java Articles

Comments

Leave a Reply