[cx-oracle-users] insert LONG RAW into table

[Jeffrey M. <jm...@gm...>]

I'm having trouble inserting a long raw into a table.

My update statement is this:
insert = """insert into amazonmp.transmission_in (msg_id, key_value,
key_value2,msg_body)
values (sys_guid(), :ref_id, :resp_id, :msg_body)"""

After doing this:

upd.setinputsizes(msg_body=cx_Oracle.LONG_BINARY)
upd.execute(insert, {"msg_body":doc.xml_encode(), "ref_id":ref_id,
"resp_id":str(id)})

I always get this error:
cx_Oracle.DatabaseError: ORA-00932: inconsistent datatypes: expected NUMBER
got BINARY

Any help would be appreciated.

This is using cx_Oracle 5.03 connecting to a 10g DB.

-Jeff