[cx-oracle-users] Getting CLOB values

[Michael M. <mi...@ma...>]

Hi,

I'm rather new to Python so please excuse any mind blowingly dumb 
errors below....

I'm trying to write a script to download and format data from Oracle 
one column of which is a CLOB. I've hit a problem with my script shown 
with the minimal test case below


Mac OS X 10.3.4,
python 2.3.4 (non-framework build (as cx_Oracle didn't build against 
the framework one...)
connecting to 9i on Solaris)

(password and host information removed..)

######
#!/opt/local/bin/python

import cx_Oracle

user = 'mike'
password = '...'
sid = '.....'
host = '....'
port = 1521

dsn = cx_Oracle.makedsn(host,port,sid)
connect = cx_Oracle.connect(user,pass,dsn)
cursor = connect.cursor()

cursor.execute("select aa_seq from gene3d_admin.g3d_seq")

for value, in cursor:
         value.read()

#####

Traceback (most recent call last):
   File "test.py", line 19, in ?
     value.read()
cx_Oracle.InternalError: No Oracle error?

I can get the non-CLOB columns with no problem. I'm confident I'm doing 
something dumb but extensive googling hasn't helped... any ideas?