Pete Finnigan's Oracle Security Forum


    
      
        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 9^th, 2006, 3:18pm)

Title: store images in Oracle
Post by Pete Finnigan on May 9^th, 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 17^th, 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 17^th, 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