Re: [cx-oracle-users] Strange behavior when using SessionPool and cx_Oracle

[Richard M. <ri...@we...>]

Hancock, David (DHANCOCK) wrote:
> above. Currenly, some product report's sizes are bigger than expected
> (>4000 chars), so they are failed to get stored and the error code is: 
> 
>            ORA-01461: can bind a LONG value only for insert into a LONG
> column
> 

I hit a similar issue the other day, your limit of 4000 is the same as 
the cx_Oracle limit on a string, something along the lines of:

  cursor.setinputsizes('3'=cx_Oracle.LONG_STRING)

will get things to the DB rather than failing in the binding.

Rich.
-- 
Richard Moore, Principle Software Engineer,
Westpoint Ltd,
Albion Wharf, 19 Albion Street, Manchester, M1 5LN, England
Tel: +44 161 237 1028
Fax: +44 161 237 1031