My apologies - I forgot to mention the photo field is a LONG RAW and
that the table already exists.
In the table definition the field is now defined as Column
('employee_photo', OracleRaw(100000)) and code that is trying to write
to the table is:
u = idworks.update().where(idworks.c.emplid=='800014023').values
(date_acquired=bindparam('date_acquired'), employee_photo=bindparam
('employee_photo', type_=OracleRaw(100000)))
dbconn.execute(u, photo=img, date_acquired='20-JAN-2009',
employee_photo=img)
Here is the error:
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
(actual: 11813, maximum: 2000)
Gregg.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
