Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: ORA-01461:

982700Jan 3 2013 — edited Jan 10 2013
Caused 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2013
Added on Jan 3 2013
6 comments
4,557 views