Re: Insert bitmaps into database ?

Hi

Bitmaps should be stored in LONG RAW columns, not in LONGs. To insert them you need to get the hex string representing a bitmap. Then INSERT it like this: insert into tab values('AB233D3E').

Otherwise use DBMS_SQL package or even OCI, there are ways to manipulate longs.

Hope this helps
Karen Abgarian.

Magnus S. Petersen wrote:

> Using PO7 and Delphi 3 C/S
> How would one insert a bitmap into a column(LONG) of a table, using standard
> SQL syntax
> INSERT INTO Table
> (column1,column2,LongColumn)
> VALUES
> (colvalue1,colvalue2,TheBitmap);
> I have some bitmaps which i want to insert, but cannot figure out how to do
> it.
> Please advice
>
> Regards
> Magnus
Received on Thu Aug 19 1999 - 13:51:24 CDT