Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2008
    Posts
    4

    Unanswered: ORA-01461 - Can Bind a LONG value

    Dear All,

    we have been experiencing this problem in our production environment since we have migrated from Oracle9i to Oracle 10G. However we could not generate this problem in local environment. Please see our database settings (same to production environment).

    NLS_LANGUAGE = AMERICAN
    NLS_CHARACTERSET = AL32UTF8
    NLS_LENGTH_SEMANTICS = CHAR
    NLS_RDBMS_VERSION = 10.2.0.3.0
    JDBC Driver: 10.2.0.2.0


    Our JSP fields allow 1000 characters to be inserted in Varchar2(4000) fields. So even if a full length String of 1000 characters of 4-byte each is entered by a user it should be inserted into the database without any problem.

    Could you please tell us what might be the reason of getting this exception?

    / Achilles
    Last edited by nawazijaz; 04-02-08 at 03:39.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •