Problem in fetching blob or clob data with python and cx_oracle

[goswami.anjan]

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 problemis 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