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

[Rodney B. <ba...@pl...>]

Maybe this is the same problem I ran into about a year ago.  I posted some
patches to the cx_Oracle tests to illustrate:
http://sourceforge.net/mailarchive/forum.php?thread_name=001201cc1bd9%248295
5660%2487c00320%24%40com&forum_name=cx-oracle-users

I don't know how to fix the problem, but I think I avoided it by converting
my unicode values to str.

Rodney

-----Original Message-----
From: Shubhanan Bakre [mailto:sb...@et...] 
Sent: Monday, June 04, 2012 8:28 PM
To: cx-...@li...
Subject: [cx-oracle-users] ORA-01461: can bind a LONG value only for insert
into a LONG column

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
----------------------------------------------------------------------------
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users