This discussion is archived
0 Replies Latest reply: Dec 5, 2012 3:27 AM by 932230 RSS

how to save photo in tabular form 10g

932230 Newbie
Currently Being Moderated
i created form (tabular style) in forms 10g on the base one table A.

i create four button and want to select picture and save against the id.
i mean if i select button 1 against the id 1 then that photo must be saved againt id 1.
and if i select button 2 against the id 2 then that photo must be saved againt id 2.


ID EMP_NAME
-- ------
1 a
2 b
3 c




CREATE TABLE A
(
ID VARCHAR2(20),
EMP_NAME VARCHAR2(200),
IMG BLOB DEFAULT '');


when i create form(form style) in forms 10g. picture is saved correctly with this coding.
please help me.


declare
vfilename varchar2(3000);
begin
vfilename := client_get_file_name('c:\', file_filter => ' Image files (*.jpg)|*.jpg|');
client_image.read_image_file(vfilename,'jpg','a.img');
client_image.write_image_file(vfilename,'jpg','a.img',maximize_compression,ORIGINAL_DEPTH);
end;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points