Re: Long Raw (BLOB) Processing - How to Insert in O7?

> Does anyone know the SQL syntax to insert a "BLOB" Binary Large
 OBject, > into the Oracle 7 Long Raw datatype? Other than using the Oracle
> Pre-Compiler and C, is > there a means to insert information in these
 fields.
> My primary are of interest is for Visual Basic. I am familiar with
 OLE 2.0 and
> Oracle Objects but have an application that was written utilizing Visual
Basic > and Q+E/VB. The Q+E/VB product supports utilization of these fields for BMP's > but we want to store compressed JPEG files. A fix is two versions away per > Q+E. As a > work around, I was wondering if it was possible to utilize a SQL > pass through statement or some other means to insert data into the Long Raw > datatypes in O7?

Have you tried using Forms 4 using the built-in function 'read_image_file'? I used it recently with no problem. I attached it to a button trigger to load a .BMP into an image item which was mapped to a LONG RAW in my table. After loading it, I simply pressed COMMIT. That's it! According to the docs, it's capable of loading TIF, JFIF, BMP, PCX, and PICT. I don't know if it supports JPEG at this time, but you could convert it first. Perhaps it supports compressed TIF. Received on Sun May 14 1995 - 00:00:00 CEST