cx_Oracle and NCLOBs

[[12]Nitro]

Greetings,

I'm currently working in a Python project to create a multi-platform
database replication tool, and cx_Oracle was the chosen provider to
handle the Oracle connections. So far the results have been very
interesting, but I've been experiencing some problems when inserting
CLOB objects through executemany (meaning, using a pre-prepared
statement and a dynamic list of parameters). Namely, somehow the
provider seems to be converting the data to LONG rather than to CLOB,
even though the statement explicitly calls out the TO_NCLOB function;
therefore, we get ORA-01461 errors.
Now, this may possibly not be an error, but instead a misusage (not
many examples available, anyways). Any help/suggestion you can provide?

Best regards,
Nitro

 

[=?ISO-8859-1?Q?Bernard_Delm=E9e?=]

Sorry I have no direct answer for you, but suspect you should
post to the cx_Oracle group. Check the sourceforge project page.
It is also conveniently mirrored at news.gmane.org.