0 Replies Latest reply: Dec 5, 2012 5:27 AM by 932230 RSS

    how to save photo in tabular form 10g

    932230
      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;