[odb-users] Inserting CLOB greater having size greater then 12288

[Boris Kolpackov]

roberto minarelli <roberto.minarelli.de at gmail.com> writes:

> I am trying to inserting a  in a column specified as CLOB more than 12288
> chars, that appears to be the actual limit
>
> ORA-01461: can bind a LONG value only for insert into a LONG column

I don't believe you should be getting this error when trying to insert
this amount of data into CLOB. I suspect you are trying to insert it
(perhaps by mistake) into, for example, a VARCHAR2 column. I would
suggest that you create a separate test with a single object that
contains a single column of the CLOB type (plus the id column) and
try this. If you are able to insert more than 12288 characters in
this test, then there is something wrong with your application.

Also see:

https://stackoverflow.com/questions/9156019/ora-01461-can-bind-a-long-value-only-for-insert-into-a-long-column-occurs-when/14497831