Help, please - inserting data into LONG RAW

I have a table set up with a long raw column, which I'd like to use to store multimedia files, etc. I'm writing a Pro*C program to accomplish this task. I'd prefer not to read an entire graphics file from the file system into one host variable and then try to throw that into the database (the files may end up being enormously large), so I was hoping to try and process reading the file in batches and concatenating it to the existing value. I've been able to concatenate to a varchar2 field via this method, but the long raw keeps giving me inconsistent data types (ORA-00932) at runtime for the following statement:

EXEC SQL UPDATE table SET long_raw_col = long_raw_col || :buffer WHERE

   object_id = :obj_id;

Anybody have any ideas?

Thanks,
Jennifer Regener Received on Sun Nov 17 1996 - 00:00:00 CET