java.sql.SQLException: ORA-01461:
982700Jan 3 2013 — edited Jan 10 2013Caused by: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
I'm getting the above exception while trying to insert a value to the column (varchar 2 (5 BYTES)).
When I inserted a value which is greater than 5 bytes and less than 4000 bytes I'm getting the corresponding exception saying that "value too long...." which is expected.
But to my surprise when I tried to insert a value which is greater than 4000 bytes in the same column, I'm getting the exception (Caused by: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column).
Why is this behaviour?
Please suggest.
Oracle version: 10.0.2.0
Thanks in advance
Edited by: 979697 on Jan 3, 2013 4:02 AM