RAW columns have a max of 2000 bytes (http://www.orafaq.com/wiki/
RAW ). you want to create your table with a BLOB column for more than
that.
On Jan 20, 2009, at 11:12 AM, Gregg Parks wrote:
>
> Michael,
>
> I read the expression language tutorial and found the section on
> bindparam. So, here's what I came up with:
>
> idworks = Table(
> 'ps_ih_idworks', metadata,
> Column('emplid', String(11), primary_key=True),
> Column('date_acquired', Date),
> Column('employee_photo', OracleRaw))
>
> u = idworks.update().where(idworks.c.emplid=='800014023').values
> (employee_photo=bindparam('photo', type_=OracleRaw))
> dbconn.execute(u, emplid='800014023', photo=img)
>
> The message given is: ORA-22835: Buffer too small for CLOB to CHAR or
> BLOB to RAW conversion (actual: 11813, maximum: 2000)
>
> What am I missing?
>
> 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
-~----------~----~----~----~------~----~------~--~---
