Pete Finnigan's Oracle Security Forum (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
Oracle General >> General Oracle questions >> store images in Oracle
(Message started by: Pete Finnigan on May 9th, 2006, 3:18pm)

Title: store images in Oracle
Post by Pete Finnigan on May 9th, 2006, 3:18pm
Hello everyone!

Could anybody give me suggestions for my problem..

1) I need to store an image (gif or bmp) in an Oracle table

2) I then need to retrieve that image using VB to a VB Front-End


Thank you for any help or advise. It will be much appreciated.

Best Regards,
Ken.

Title: Re: store images in Oracle
Post by Pete Finnigan on May 17th, 2006, 10:59pm
Ken,

1.  Read the docs about BLOB types
2.  Study the PL/SQL docs, specifically the dbms_lob package
3.  Create a table with a BLOB type

Take it from there.

rr

Title: Re: store images in Oracle
Post by Pete Finnigan on May 17th, 2007, 8:15am
krishna kumar.m

hey

1. create the directory in oracle database.

2. put the image file into directory.

3.then call the path into 'insert' query.

further any doubt plz conact oracle_krish@yahoo.co.in



Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board