Page 1 of 1
Image Storage in DB
Posted: Tue Sep 19, 2006 10:21 am
by 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
Posted: Wed Sep 20, 2006 1:39 am
by 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
Posted: Wed Sep 20, 2006 2:47 am
by Kashif
Dear Ahmad sb
this is not my Requirment.
I want ot Store Image in the ORACLE DATABASE TABLE.
Posted: Wed Sep 20, 2006 2:51 am
by 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
Posted: Mon Sep 25, 2006 4:37 am
by Kashif
still waiting for ur example fmb or code
Posted: Mon Sep 25, 2006 4:44 am
by 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
Posted: Tue Sep 26, 2006 1:25 am
by ahmadbilal
Check Your hotmail for example developed in 6i
kashifsbr@hotmail.com
From
abmian1981@hotmail.com
Posted: Tue Sep 26, 2006 2:13 am
by 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?
Posted: Tue Sep 26, 2006 2:29 am
by ahmadbilal
Check The path In Post-Query or write same code as on button