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

[kulkarni08]

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

[Srinivas_Sharma]

http://www.error-bank.com/microsoft....81_Thread.aspx

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

Srini