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

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

Hi,

I'm using cx_Oracle 4.0.1 on SuSE 9.0 with Oracle 10gR1. I've found that 
fetchall does not work properly for CLOB fields - all the rows come back 
with the CLOB field having the same value (the other fields are fine). 
It works find if I use fetchone().

This causes a problem:

  for row in self.cur.fetchall():
    ....

But this is fine:

    row = self.cur.fetchone()
    while row:
       ...
      row = self.cur.fetchone()

We're happy with the workaround for now, so this isn't urgent, but I 
hope this bug report is useful.

Regards,

Paul

-- 
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