how to manage CLOB type with cx_oracle

2009-03-03 Thread Loredana
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', 'L

Re: how to manage CLOB type with cx_oracle

2009-03-03 Thread Loredana
On Mar 3, 1:01 pm, Loredana wrote: > 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 = {'na

Re: how to manage CLOB type with cx_oracle

2009-03-03 Thread Gabriel Genellina
En Tue, 03 Mar 2009 13:33:19 -0200, Loredana escribió: On Mar 3, 1:01 pm, Loredana wrote: 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()

Re: how to manage CLOB type with cx_oracle

2009-03-03 Thread Loredana
On Mar 3, 5:12 pm, "Gabriel Genellina" wrote: > En Tue, 03 Mar 2009 13:33:19 -0200, Loredana   > escribió: > > > > > > > On Mar 3, 1:01 pm, Loredana wrote: > >> Hi, > > >> I need to read CLOB field type (it is long text) > > >> if I use this code: > > >> curs.execute(sqlstr) > >> rows['name_of_c

Re: how to manage CLOB type with cx_oracle

2009-03-03 Thread Gabriel Genellina
En Tue, 03 Mar 2009 15:23:38 -0200, Loredana escribió: I try this code and it works: curs.execute(sqlstr) for rows in curs: for col in rows: try: print col.read() except: print col onother q