Re: [cx-oracle-users] Fwd: cx_Oracle and NCLOBs

[Anthony T. <ant...@gm...>]

Are you using the setinputsizes() call to specify that you are
interested in CLOB (or NCLOB)?

cursor.setinputsizes(fred = cx_Oracle.CLOB)
cursor.setinputsizes(fred = cx_Oracle.NCLOB)

If you don't, Oracle assumes you want LONG and barfs appropriately. :-)

On 11/10/06, Nuno NiTrO <12....@gm...> wrote:
> 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
>
> --
> NiTrO. From Portugal, with love.
>
>
> --
> NiTrO. From Portugal, with love.
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>