Images

[yejurvad]

Hi,

Can someone help me out on how to insert an image into the table throgh PL/SQL.

I've got a
table img(
f1 number,
f2 blob)

Through PL/SQL how i can insert data into the table.

Waiting for an early reply.

Warm Regards,
Raghava Rao.

[julian]

I insert images (BLOBs) into the database via Forms. If you use Forms I could tell you how to do it.

[TimHall]

Have you considered using interMedia to hold your images. It's actually quite good. Intermedia has import functionality built in, and in later versions of 8i export facilities too. This is all done via directory objects or you can do it through java like:

http://www.oracle-base.com/Articles/...rtOfImages.asp

If you'd rather stick with your BLOB you can use something like this:

http://www.oracle-base.com/Articles/8i/ImportBlob.asp

Cheers

[Edited by TimHall on 01-31-2002 at 06:16 AM]