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!

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

842868Aug 8 2011 — edited Aug 9 2011

Hello,

We have been getting the following exception when we try to save an XML (>5k).
SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column

This is occurring only for Oracle 11g (11.2.0.1.0)

Our column is CLOB type, not LONG type.

Could anyone please suggest what could be the reason and fix?

Thanks in advance

--Cheers
paruvid

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2011

Added on Aug 8 2011

#general-database-discussions

3 comments

1,384 views