Re: How to save GIF file in Oracle?

In article <3o2oib$51q_at_redwood.cs.scarolina.edu>, sjohnson_at_math.scarolina.edu (L. Scott Johnson) wrote:

>Kenneth Yuen <itkennet_at_hkpucc.polyu.edu.hk> writes:
>
>>Does anyone experience store Graphic/Image file in Oracle database? How
>>can it be done in Oracle?
>>
>>Thanks for your attention and your help in advance.
>
>Use a LONG RAW column (possibly just a LONG now - I haven't used V.7),
>and fill your variable in PRO*C (or somesuch 3GL). fread() works well
>for this. Then use the standard
>
>EXEC SQL INSERT INTO MY_TABLE (ID, IMAGE) VALUES
>:ID, :IMAGE_BUF;
>
>to load it into the table.
>--
>L. Scott Johnson (sjohnson_at_math.scarolina.edu)
>Graphics Specialist and Jyhad Rulemonger.

Either method will work -- I have sucessfully tried the Sql*Forms process. I will soon try the PRO*C process to load more images.

Does anybody know of an off the shelf API or example code to display gif/tiff/bmp other graphic formats in C?

-- 
_____________________________________________________
Rick Michaud
Senior Systems Officer
1 Court Square, 39th Floor
Long Island City, NY  11120
_____________________________________________________