[cx-oracle-users] LOB limitations and Oracle 10.1 and up.

[Martijn P. <mj...@zo...>]

Hi!

What's the status of LOB support in cx_Oracle, regarding the use of
the new oraub8-sized read and write API introduced in OCI 10.1? See:

  http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10779/oci07lob.htm#444308

Currently, on 32-bit systems, you can only handle up to 2GB of data
when it comes to LOBs, as the offset parameter on the read and write
operations only takes a python int (and not a long), which being
signed is limited to half the Oracle limit.

It'd be great if at least that API would take a python long up to the
limits of the ub4 4-byte unsigned int and let us work with 4GB LOBs,
or better still, use the new OCILob*2 operations and let us access the
full potential of Oracle LOBs, all the way to the terrabyte range! :-)

-- 
Martijn Pieters