Skip to Main Content

Oracle Database Express Edition (XE)

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 in a CLOB field??

470043May 29 2006 — edited Jun 5 2006
I'm getting an error

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

when I fill a CLOB field. The error is reproducable but when I look at the content there is nothing suspicious in there. It happens with two records out of 1095 which work well. The content is some source code of our ERP system.

I did change the character set in the registry key NLS_LANG from GERMAN_GERMANY.WE8MSWIN1252 to GERMAN_GERMANY.WE8ISO8859P1 to be able to access our 8.1.7 databases.

Has someone else seen something similar, or knows what I could do?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2006
Added on May 29 2006
2 comments
257 views