This discussion is archived
3 Replies Latest reply: Jan 30, 2013 6:50 AM by Amatu Allah RSS

how to set image size in d2k6i forms

988002 Newbie
Currently Being Moderated
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

Legend

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