Re: How to save GIF file in Oracle?
From: L. Scott Johnson <sjohnson_at_math.scarolina.edu>
Date: 1995/05/01
Message-ID: <3o2oib$51q_at_redwood.cs.scarolina.edu>#1/1
Date: 1995/05/01
Message-ID: <3o2oib$51q_at_redwood.cs.scarolina.edu>#1/1
Kenneth Yuen <itkennet_at_hkpucc.polyu.edu.hk> writes:
>Does anyone experience store Graphic/Image file in Oracle database? How
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.
>can it be done in Oracle?
>
>Thanks for your attention and your help in advance.
--
L. Scott Johnson (sjohnson_at_math.scarolina.edu)
Graphics Specialist and Jyhad Rulemonger.
Received on Mon May 01 1995 - 00:00:00 CEST