how to manage CLOB type with cx_oracle

Loredana loredana.pier at gmail.com
Tue Mar 3 07:01:46 EST 2009


Hi,

I need to read CLOB field type (it is long text)

if I use this code:

curs.execute(sqlstr)
rows['name_of_columns']     =   name_of_columns
rows['data']                         =   curs.fetchall()

it returns me this values:

test = {'name_of_columns': ['FILENAME', 'CRONTIME', 'SHORT_TAIL',
'LONG_TAIL'], 'data': [('dd','asdds','adadsa',<cx_Oracle.LOB object at
0x2a955bc230>')]}

any ideas?

Thanks

Lory




More information about the Python-list mailing list