Problem in fetching blob or clob data with python and cx_oracle

[goswami.anjan at gmail.com]

It seems that when I attempt to download blob or clob data using fetchmany, it can not keep track of the LOB variable in subsequent fetch. The problem is over if I fetch one row at a time but it is not optimal. Can anyone give me an idea how to efficiently fetch columns with clob or blob data from oracle DB using python.

Thank you,
Anjan