Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting photo into BLOB data type

Status
Not open for further replies.

teknikalbody

Programmer
Mar 2, 2003
35
GB
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
 
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
 
Hi,

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

TIA
 
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:


Hope this helps!

Regards
Bobby
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top