Re: [cx-oracle-users] Bug: CLOB fields and fetchall()

[Paul J. <pa...@we...>]

Hi Anthony,

Thanks for your explanation. That alternative syntax is much neater too.

Take care,

Paul


>This is a known issue with cx_Oracle 4.0.1 which is resolved in 4.1
>but probably not the way you expect. :-) A programming exception is
>raised when this situation is detected rather than simply providing
>incorrect information. This is necessary because of the way that
>Oracle works. BTW, you can more effectively do the following:
>
>for row in cursor:
>    print "Do something with the row."
>
>which iterates over the rows safely. Hope this helps.
>  
>
-- 
Paul Johnston, GSEC
Internet Security Specialist
Westpoint Limited
Albion Wharf, 19 Albion Street,
Manchester, M1 5LN
England
Tel: +44 (0)161 237 1028
Fax: +44 (0)161 237 1031
email: pa...@we...
web: www.westpoint.ltd.uk