Image Storage in DB

[Kashif]

Dear all Members

How do i Store Images in the Database, and Retrieve them.
I want to Store Employee Image in the Database.

Please give an example.

thanks

[ahmadbilal]

:System.Message_Level := '25';
if :STF_EMP_PROFILE.emp_code is not null then
read_image_file('\\sscora\admin\staff\'||:emp_code||'.bmp','BMP','STF_EMP_PROFILE.photo');
end if;
IF NOT FORM_SUCCESS THEN
read_image_file('\\sscora\admin\staff\'||'sorry.bmp','BMP','STF_EMP_PROFILE.photo');
END IF;
:SYSTEM.MESSAGE_LEVEL := '0';

u can do by using this code
if you need form fmb file then send me a blank email on
abmian1981@gmail.com

[Kashif]

Dear Ahmad sb
this is not my Requirment.
I want ot Store Image in the ORACLE DATABASE TABLE.

[ahmadbilal]

Mr Kashif
You Can Store Image In Database By Placing The Image In anyfiled(Database Blob).this code will help you to place your image in database field on FORM.i will send you sample form(FMB) tomorrow for better understanding.
take care

[Kashif]

still waiting for ur example fmb or code

[ahmadbilal]

Sorry Buddy I Will Do It In one or two days

Visit Following Page

http://asktom.oracle.com/pls/ask/f?p=49 ... 9814548726

[ahmadbilal]

Check Your hotmail for example developed in 6i
kashifsbr@hotmail.com

From abmian1981@hotmail.com

[Kashif]

Thank Mr. Ahmad.

Images is Stored in the database but when i Query the Record. other Fields Like ID and Title are displayed but IMGAE empty?

[ahmadbilal]

Check The path In Post-Query or write same code as on button