[cx-oracle-users] ORA-01461: can bind a LONG value only for insert into a LONG column

[Shubhanan B. <sb...@et...>]

Hi,

I have this strange issue when inserting a unicode string into a varchar2(4000 byte) field.
cx_Oracle tries to bind it to a LONG value, however all the characters in the string are English.

Table ddl:

CREATE TABLE TEST(
"NOTES" VARCHAR2(4000 BYTES)
);

INSERT INTO TEST (NOTES) VALUES (:NOTES);

The python value dict for the above insert is as follows:
{'NOTES': u'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   '}

This throws the following error:
ORA-01461: can bind a LONG value only for insert into a LONG column

Any help will be appreciated.
Thanks!
Shubhanan