3 Replies Latest reply: Jan 30, 2013 8:50 AM by Amatu Allah Neveen Ebrahim RSS

    how to set image size in d2k6i forms

    988002
      I have upload an image in forms6i, in oracle apps

      this code runs smoothly when images size is croped using microsoft picture manager.

      and those images are not croped or size more than 50kb it shows frm-47100 can not read image file \\...........

      is there any query to reduce the size of photo.

      pls help me.

      code is :-

      DECLARE
      tiff_image_dir VARCHAR2(80) :=:parameter.P_pm_photo_path;
      photo_filename VARCHAR2(80);
      MYEAR VARCHAR2(2);
      MROLL VARCHAR2 (4);
      MYEAR3 VARCHAR2 (2);
      BEGIN
      :System.Message_Level := '25';
      MYEAR := SUBSTR(:BW_STUDENT.STU_V_YEAR,3,2);
      MROLL := LPAD(:bw_student.stu_v_roll_no,4,'0') ;
      MYEAR3 :=TO_NUMBER (SUBSTR(:BW_STUDENT.STU_V_YEAR,3,2))+3;

      photo_filename:=tiff_image_dir||''||MYEAR||''||MROLL||''||MYEAR3||''||'.jpg';

      If
      nvl(photo_filename,'X')=tiff_image_dir
      then
      null;
      else
      READ_IMAGE_FILE(photo_filename, 'jpg', 'bw_student.STU_PHOTO');
      end if;
      END;

      thanks.

      Edited by: 984999 on Jan 30, 2013 12:57 AM