I built an application with PyADO, connecting to oracle.

Now a kind member of this newsgroup sent me prebuilt binaries of
DXOracle, and I tried to exchange PyADO with DXOracle.

But:

when doing a query, PyADO returns a list of lists, like
[["James","Curtis","singer","somewhere"],
["Sandra","Bullock","actress","ny"]]

DXOracle returns a list of tuples
[("James","Curtis","singer","somewhere",),
("Sandra","Bullock","actress","ny",)]

So my application stumbles because of minor differences between lists and
tuples.

To convert I can do:

a=[('nasen','baeren',23,),('nasen','drosseln',12)]  #the list of tuples

d=[] # empty list
for i in a:
...     d.append(list(i))

which returns:
[['nasen', 'baeren', 23], ['nasen', 'drosseln', 12]]

    tuple(seq)

Similarly, to convert a tuple (or any sequence) to a list, use

    list(seq)

It's really as easy as that.

ciao,

i.e. it depends on what's in the tuple.  Hashable means immutable throughout.

Cheers,
Terry

--
Terry Hancock ( hancock at anansispaceworks.com )
Anansi Spaceworks  http://www.anansispaceworks.com

the solutions from you with the timing added:

d=[] # empty list
for i in fetchall():
   d.append(list(i))

maybe written as

d=[list(i) for i in fetchall()]

or as

d=map(list,fetchall())

With timing of

Dauer 3.98594933547  for
Dauer 3.52617203411  list
Dauer 2.3300359878  map

best wishes

--
Regards, Bogdan