Inserting photo into BLOB data type

[teknikalbody]

Hi all,


Is it possible for me to insert a ‘.jpg’ photo into the table that holds photos in BLOB format?

Any suggestions are appreciated.

TIA

 

[bobby13]

Hi,

I'm not sure about jpeg images but you can surely insert bitmap images in BLOB format, cause I do that quite often.

Regards
Bobby

 

[teknikalbody]

Hi,

I have the images saved on my C drive. Can you please explain how I can insert them into the table.

TIA

 

[bobby13]

I use Oracle Forms to insert images into the database, I'm afraid I can't help you on the actual details of how it works, but you can use sql loader to import an image into your table, but to view it you would need something like Oracle Forms or similar software to display the stored image.

Try this link, its a white paper on adding audio, video and images into Oracle 9i databases:

http://www.lc.leidenuniv.nl/awcourse/oracle/appdev.920/a88786/mm_intr.htm#624881

Hope this helps!

Regards
Bobby