[sqlalchemy] Re: Loading JPG images into an Oracle Long Raw field

2009-01-20 Thread Gregg Parks
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),

[sqlalchemy] Re: Loading JPG images into an Oracle Long Raw field

2009-01-20 Thread Michael Bayer
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,

[sqlalchemy] Re: Loading JPG images into an Oracle Long Raw field

2009-01-20 Thread Gregg Parks
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(10)) and code that is trying to write to the table is: u =

[sqlalchemy] Re: Loading JPG images into an Oracle Long Raw field

2009-01-20 Thread Michael Bayer
first, try this patch: Index: lib/sqlalchemy/databases/oracle.py === --- lib/sqlalchemy/databases/oracle.py (revision 5695) +++ lib/sqlalchemy/databases/oracle.py (working copy) @@ -258,9 +258,19 @@ return process