Home » Developer & Programmer » Reports & Discoverer » error - rep-0108 file '- - - - - .jpg' not found (oracle report6i)
error - rep-0108 file '- - - - - .jpg' not found [message #589939] Fri, 12 July 2013 05:03
subhash_pandit
Messages: 1
Registered: December 2012
Location: delhi
Junior Member

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. all images are in .jpg format.

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.

[Updated on: Sat, 13 July 2013 02:38]

Report message to a moderator

Previous Topic: Down Cross Printing Direction
Next Topic: oracle reports builder 11g stops when destype is file
Goto Forum:
  


Current Time: Tue Mar 19 00:04:40 CDT 2024