[DB-SIG] cx_Oracle and BFILE's
matthew.cahn at bms.com
Wed May 17 16:08:42 CEST 2006
I have an application which uses Oracle (8i and 9i, but eventually
10g). It uses DCOracle2, partly for historical reasons, but also
because DCOracle2 handles BFILE's. (BFILE's are like BLOB's, but the
data is stored outside the tablespace.)
Apparently cx_Oracle doesn't handle BFILE's:
>>> cur.execute('select image from observation')
Traceback (most recent call last):
File "<stdin>", line 1, in ?
cx_Oracle.NotSupportedError: Variable_TypeByOracleDataType: unhandled
data type 114
I'd like to switch from the unsupported DCOracle2 to cx_Oracle. BFILE's
are important to the application because we'll have a couple of
terrabytes of images and I don't want to make a tablespace that big.
Could anyone comment on the possibility of adding BFILE support to
cx_Oracle, or the difficulty of doing so?
More information about the DB-SIG