[cx-oracle-users] Inserting BLOBs with cx_Oracle 3.0

[Jeff W. <jef...@sa...>]

Hi,

Is it possible to insert BLOBs using cx_Oracle 3.0?  I have been able
to do it like this using cx_Oracle 4.0:

v = cursor.var( cx_Oracle.BLOB, len( stuff ))
v.setvalue( 0, stuff )
cursor.execute( "insert into blob_test values ( :blob ) ", {'blob', v } )

You can't do this in cx_Oracle 3.0 because the BLOB constant is not
defined.  Using the BINARY constant doesn't work because I will get
complaints from setvalue about the string data being too large.  (I am
inserting BLOBS of
greater than 4000 bytes.)

I understand that I could upgrade but I'd like to avoid doing that if
possible.