User:Subhash pandit

hi, i am using report 6i to display image from a file path .when no image there it gives rep-0108 file '............20132.jpg' not found.

query is

FUNCTION cf_1formula RETURN CHAR IS

  tiff_image_dir   VARCHAR2 (200) := :p_coll_photo;
  photo_filename   VARCHAR2 (200);

BEGIN

  photo_filename := tiff_image_dir || :myear || :mroll_no || '.' || 'JPG';

  IF NVL (photo_filename, 'X') = tiff_image_dir
  THEN
     RETURN NULL;
  ELSE
     RETURN photo_filename;
  END IF;

EXCEPTION

  when no_data_found then 
      return (:p_coll_photo||'no_image.jpg');
  When Others Then
      if sqlcode=-302000 then
          return (:p_coll_photo||'no_image.jpg');
      end if; 

END;

thanks in advance.