ORA-01461: can bind a LONG value only for insert into a LONG column
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01461: can bind a LONG value only for insert into a LONG column

  1. #1
    Join Date
    Aug 2001
    Posts
    30

    ORA-01461: can bind a LONG value only for insert into a LONG column

    Hi,
    This Problem was originally discovered by simply putting in large amounts of text into a textbox that would be inserted into a varchar2 field in the database.
    The varchar2 type does not allow values greater than 4000 bytes to be
    inserted. So, upon exceeding 4000 characters, this error was thrown.
    However, entering 4000 characters, saving, then backspacing over 5
    characters would also cause the error, despite that only 3995 character were going into the update statement.

    A variety of different numbers of characters were tried, with the same
    problem happening even with just 2000 (1995 after backspacing) characters in the box upon submits. Many things were attempted to see what might correct the problem: cutting the box off at 4000 character did not correct it because less characters could still potentially cause it. Trying to parse through the string before it was put in the update statement and remove any non alphanumeric characters did not work.

    I am still getting
    ORA-01461: can bind a LONG value only for insert into a LONG column
    error.

    Thanks
    Kulkarni
    Sitaram KUlkarni

  2. #2
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    http://www.error-bank.com/microsoft....81_Thread.aspx

    something similar to ur prob, theres a solution too...

    Srini

Posting Permissions

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


Click Here to Expand Forum to Full Width