[cx-oracle-users] Inserting BLOBs with cx_Oracle 3.0
Brought to you by:
atuining
|
From: Jeff W. <jef...@sa...> - 2004-04-27 21:27:15
|
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.
|