[cx-oracle-users] Bug: CLOB fields and fetchall()
Brought to you by:
atuining
|
From: Paul J. <pa...@we...> - 2005-03-31 14:06:42
|
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
|